November 4, 2008 at 11:02 pm
HI
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 ?
Please Help
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 9, 2008 at 1:03 am
[font="Verdana"]I am not sure, but I think your servers must be linked servers. First link them and then try. (May be I guess right)
Mahesh[/font]
MH-09-AM-8694
November 9, 2008 at 10:34 pm
hi mahesh ..iys not like that i have liniked the server buyt still this error occurs..
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 9, 2008 at 11:08 pm
navigate the following URL's you will get the answer:
Code:
------
Needed to Set NOCOUNT ON and change
sp_configure "user options", 512
to
sp_configure "user options", 0
URL's:
------
http://support.microsoft.com/kb/195491
http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic10693.aspx
November 10, 2008 at 12:04 am
thanks buddy it works !!!!!!!!!!
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 30, 2014 at 11:49 am
Very good. This saved me. I can't figure out which config setting it changed, though.
August 7, 2014 at 4:23 am
I just read all the views here and now little bit understand the problem. I will get you back soon after resolve it.:-)
August 7, 2014 at 8:46 am
louisscott (8/7/2014)
I just read all the views here and now little bit understand the problem. I will get you back soon after resolve it.:-)
Please note...this thread is 6 years old. 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply