>>>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