INSERT INTO [srsvr\dev].db_lines.dbo.SYNC_OBJECT_RECEIVE_IN_M(object_name,eventtype,Created_by)
SELECT TOP 2 object_name,eventtype,Created_by FROM db_lines.dbo.SYNC_OBJECT_SEND_HQ_M Order By Created_by
I m executing above remote query and its giving error
OLE DB provider "SQLNCLI" for linked server "srvr\dev" returned message "Cursor operation conflict".
Msg 7343, Level 16, State 2, Line 1
The OLE DB provider "SQLNCLI" for linked server "srvr\dev" could not INSERT INTO table "[srvr\dev].[DB_line].[dbo].[SYNC_OBJECT_RECEIVE_IN_M]".
i have seen in a forum that we need to check OFF the setting in connection of server but it didnt work ?
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)