Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
klegrand
Starting Member
29 Posts |
 Posted - 2005-01-25 : 09:34:15
|
| I've created a linked server (SQLREMOTE). I can read and write data to the remote server using QueryAnalyser.I've also created a trigger (update) in a table. If data is changing, that row should be inserted in the remote server. I'm getting the following error :'Another user has modified the contents of this table or view, the database row you are modifying no longer exists in the database. Database error : '[Microsoft][ODBC SQL Server Driver][SQL SERVER]MSDTC on server C0458 is unavailable'.The logic of the trigger :CREATE TRIGGER trgUpdate ON [dbo].[tbl_Product] AFTER INSERT, UPDATEASINSERT INTO SQLREMOTE.edison.dbo.tbl_Operator (operator)SELECT ID, Brandcode, description, Trays, Packs, WeightFROM insertedCan anyone tell me what I'm doing wrong !Thanks |
|
|
|
|
|
Linked server data transfer problem