November 13, 2008 at 8:16 am
Hi,
I can successfully delete data from linked server tables using a simple delete command eg:
delete * from serveraliasname.sm.dbo.strtrig
I can select data from the linked server tables using a more complicated string:
select * from serveraliasname.sm.dbo.strtrig where striggerguid in (select striggerguid from serveraliasname.sm.dbo.strtrig where stoolguid = '{dfgd1fg2dfg3dfgd3fg}')
BUT when I try:
delete from serveraliasname.sm.dbo.strtrig where striggerguid in (select striggerguid from serveraliasname.sm.dbo.strtrig where stoolguid = '{dfgd1fg2dfg3dfgd3fg}')
I get an error:
OLE DB provider "SQLNCLI" for linked server "serveraliasname" returned message "Multiple-step OLE DB operation generated errors.
I've looked into this error but having no joy.
November 13, 2008 at 9:19 am
Does my question make any sense? I've setup a linked server by passing parameters to the following system procedures:
EXEC sp_addlinkedserver
EXEC sp_addlinkedsrvlogin
I can select, update, delete and insert data into the remote server using the linked server. However I can't delete data from the remote server if I use the 'in' command in the sql statement. I'm not an SQL expert so don't understand why all the other sql commands over a linked server work but this particular one doesn't. The statement is definately correct and there is no corrupt data.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply