>>>>Hi
>>>>
>>>>I have a user using a CRM package which uses sql2008.
>>>>
>>>>Occasionally they are getting an error message
>>>>
>>>>No SQL Cursors remaining.
>>>>
>>>>Any ideas on how to prevent this. Is it a server configuration issue or a fault in the package.
>>>
>>>Did you close and Deallocate cursors after you finish with them?
>>
>>Hi Boris
>>
>>Its a package and I don't know how thats handling cursors internally.
>
>I am thinking, you may at least check cursor options - try to use LOCAL cursors (set this as an option).
>
>Right click on the database, properties, options, look at Cursor options (by default the cursors are Global). You may change both options for CURSORS to opposite.
>
>I also found this thread, but not sure if of any help (looked through couple of others):
>http://www.tek-tips.com/viewthread.cfm?qid=992680


Hi Naomi Its a package so I have no control over how its using cursors when opening them. Is there a configuration setting for the server ?