Change default to local cursor

Question

Change default to local cursor

gayoux

SSC-Addicted

Points: 431
More actions
February 1, 2006 at 10:12 am

#168049

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

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

sushila SSC-Dedicated Points: 35293 More actions · Answer 1

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

gayoux SSC-Addicted Points: 431 More actions · Answer 2

Thank you, I've find the command :

ALTER DATABASE TEST SET CURSOR_DEFAULT LOCAL;