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 [YourDatabase] SET CURSOR_DEFAULT LOCAL;

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Elina Blank

Software Developer (Senior) The Code Project

United States

Member

Elina joined the Code Project team as a software developer in order to make the site run even smoother than it is now. She will also take care of making wishes and promises on the site improvements come to the light sooner than later. When not at work, she enjoys being with her family and wishes there will be at least 30 hours in a day Smile | :)

Article Top

Poor

Excellent

Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Alternative to 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...

Type	Tip/Trick
Licence	CPOL
First Posted	18 Oct 2011
Views	749
Bookmarked	1 time

SQLSqlServer

		9,889,766 members (26,026 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using

Always close your cursor

License

About the Author

Comments and Discussions