February 1, 2006 at 10:12 am
Hello,
I want to change the option SET_CURSOR_DEFAULT in SQL server 2000. What is the command to change the type of cursor to GLOBAL in the setting of SQL Server ?????? I search but i don't find...... Please, can you help me?
Thank's
Gaëlle
February 1, 2006 at 8:03 pm
From BOL...
Transact-SQL Extended Syntax DECLARE cursor_name CURSOR [ LOCAL | GLOBAL ] [ FORWARD_ONLY | SCROLL ] [ STATIC | KEYSET | DYNAMIC | FAST_FORWARD ] [ READ_ONLY | SCROLL_LOCKS | OPTIMISTIC ] [ TYPE_WARNING ] FOR select_statement [ FOR UPDATE [ OF column_name [ ,...n ] ] ] ...and to find out what the current default for the database is... select DATABASEPROPERTYEX('dbName', 'IsLocalCursorsDefault') 1 = TRUE 0 = FALSE NULL = Invalid input
**ASCII stupid question, get a stupid ANSI !!!**
February 6, 2006 at 3:54 am
Thank you, I've find the command :
ALTER DATABASE TEST SET CURSOR_DEFAULT LOCAL;
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy