|The Message text:
This email was created by [your name] who thought you would be interested in the following Article:
"Always close your cursor"
To see the default value of the cursor scope:select * from sys.databases(if value of "is_local_cursor_default" is 0 then scope id global, otherwise it is local).The scope is GLOBAL by default (for compatibility reasons).To change default scope use following:ALTER DATABASE...
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!