Finally it worked...


SET @SQL =N'SELECT @CHECK=keyfield FROM OPENQUERY(linkedserver,
''select keyfield from library.table where document=' + @NEXT +''')N'
EXEC sp_executesql @sql, N'@CHECK...

I am reading records from a linked server table, and trying to use the output in the next update statement, not on the linked server. I am assigning it to a declared variable. The file is being...

I found a microsoft paper explaining to turn on DTC on both servers, it was only on one server. Once I did this setup, I was able to insert data from prod server to dev server. Thanks for the...

I have production data on one server and test data on another. I need to move one record from the production server into the test table on a different server. I setup the production server as a...