Topic: There were errors in runtime of multistep operation of an OLE DB
delete from [192.168.1.99].Archive.dbo. RA where FK_R in (select FK_R from [192.168.1.99].Archive.dbo. RA as ra left join [192.168.1.99].Archive.dbo. R rr on ra. FK_R=rr.pk where rr. RegistrNum is not null)
The given request on the server [192.168.1.99], produces such error:
The supplier of an OLE DB "SQLNCLI10" for a linked server "192.168.1.99" returned the message "There were errors in runtime of multistep operation of an OLE DB. Whenever possible, check up values of all states of an OLE DB. Operation is not fulfilled.". The message 7202, level 11, state 2, line 1 Could not find server ' SQLSERVER2 ' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Such error is produced on one the server from 30.... On others such error is not present...
Help to understand, please...