SQLServerCentral.com / SQL Server 2005 / Development / "Cursor operation conflict" / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 02 Aug 2015 15:06:54 GMT20RE: "Cursor operation conflict"http://www.sqlservercentral.com/Forums/Topic597106-145-1.aspx[quote][b]louisscott (8/7/2014)[/b][hr]I just read all the views here and now little bit understand the problem. I will get you back soon after resolve it.:-)[/quote]Please note...this thread is 6 years old. :-DThu, 07 Aug 2014 08:46:11 GMTSean LangeRE: "Cursor operation conflict"http://www.sqlservercentral.com/Forums/Topic597106-145-1.aspxI just read all the views here and now little bit understand the problem. I will get you back soon after resolve it.:-)Thu, 07 Aug 2014 04:23:42 GMTlouisscottRE: "Cursor operation conflict"http://www.sqlservercentral.com/Forums/Topic597106-145-1.aspxVery good. This saved me. I can't figure out which config setting it changed, though.Wed, 30 Apr 2014 11:49:04 GMTjeffshumphreysRE: "Cursor operation conflict"http://www.sqlservercentral.com/Forums/Topic597106-145-1.aspxthanks buddy it works !!!!!!!!!!Mon, 10 Nov 2008 00:04:40 GMTBhuvneshRE: "Cursor operation conflict"http://www.sqlservercentral.com/Forums/Topic597106-145-1.aspxnavigate the following URL's you will get the answer:Code:------Needed to Set NOCOUNT ON and changesp_configure "user options", 512tosp_configure "user options", 0URL's:------http://support.microsoft.com/kb/195491http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic10693.aspxSun, 09 Nov 2008 23:08:49 GMTKishore.PRE: "Cursor operation conflict"http://www.sqlservercentral.com/Forums/Topic597106-145-1.aspxhi mahesh ..iys not like that i have liniked the server buyt still this error occurs..Sun, 09 Nov 2008 22:34:58 GMTBhuvneshRE: "Cursor operation conflict"http://www.sqlservercentral.com/Forums/Topic597106-145-1.aspx[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]Sun, 09 Nov 2008 01:03:16 GMTMahesh Bote"Cursor operation conflict"http://www.sqlservercentral.com/Forums/Topic597106-145-1.aspxHIINSERT 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_byI 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 1The 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 HelpTue, 04 Nov 2008 23:02:59 GMTBhuvnesh