I am a data table in SQL server 2000 tableA got a trigger, synchronous data to another server data tables, did two server connection, sp_addlinkedserver and sp_addlinkedsrvlogin ANSI_NULLS and ANSI_WARNINGS two servers are set up on, I performed in the query analyzer tableA insert, delete, update, can trigger, and another server synchronization, but in the PB insert, delete, update, all not line, tip:

Heterogeneous query requirements set ANSI_NULLS and ANSI_WARNINGS options for the connection, this will ensure that consistently query semantics, please enable these options, and then to make queries

Both my set up on the ah, how to do ah, depressed ah!!!!!!

Supplement: save the pb data window tableA before, I tried to perform a stored procedure, content is the ANSI_NULLS and ANSI_WARNINGS again set on, as no results,

CodePudding user response:

The set ansi_warnings on
Write a stored procedure?

CodePudding user response:

More table before writing code sqlca. The autocommit=true

CodePudding user response:

Really not line, using the data import/export tool or manual synchronization data pipeline,

CodePudding user response:

Watch, encountered the same problem, finally use pipes to achieve

CodePudding user response:

Reference:
http://topic.csdn.net/t/20030808/19/2125483.html

CodePudding user response:

Encounter the same problem, I am by setting the SQL SERVER connection properties, these three box

CodePudding user response: