August 24, 2007 at 1:29 pm
I'm executing a line of code from a remote box that is linked into a remote server. (sa-->sa rights). When I execute the line of code I'm getting an error consistently. However if I just log directly onto the remote box and take away the link server information and run it, the line runs just fine.
Some background, this one line of code is probably 150th in a list that goes into different tables,etc on this remote server and modifies, deletes,etc from it. It's just this one particular line that for some simply doesn't want to work.
Would anyone have some pointers as to where to go to solve the problem?
UPDATE
PS SET PS.IsChanged=1 FROM [192.168.5.100].Touchstar.dbo.ProjectStatus PS WHERE PS.ProjectID=102
All this does is change a bit flag from 0 to 1.
The error I get is:
OLE DB provider "SQLNCLI" for linked server "192.168.5.100" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
Msg 16955, Level 16, State 2, Line 1
Could not create an acceptable cursor.
August 24, 2007 at 2:50 pm
Hi, I think this doc may help you resolve this problem
http://support.microsoft.com/kb/814581
TH
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply