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

Yes and for each database. I've found it in the properties for database, but you can set it on the Server level as well.