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

   

   

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  February 1, 2006 at 8:03 pm

  #618275

  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

  February 6, 2006 at 3:54 am

  #618917

  Thank you, I've find the command :

  ALTER DATABASE TEST SET CURSOR_DEFAULT LOCAL;