Advertisement

10.08.2008 at 08:36AM PDT, ID: 23797742 | Points: 500
[x]
Attachment Details

cursor operation conflict errors suddenly start appearing

Asked by CASorter in MS SQL Server

Tags:

i have a site where cursor operation conflict errors have suddenly started appearing.

from what i read, this could be caused by issues with server side cursors for the recordsets... i had recently just changed some queries to server side cursors, so i thought that this was the problem....    so i was going to have them use an older version of the code.

it got the error too..    i went back to a version of the code that is a year old.  that got the error.

this started happening about a week ago.    
the weird thing is that   occasionally it works ok.

so my question is ..    what can change in the sql installation that might cause this error,  how do i check this setting,  and then how do i change that setting.

tia
markStart Free Trial
 
 
[+][-]10.08.2008 at 08:35PM PDT, ID: 22675497

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-44 - Hierarchy / EE_QW_2_20070628