SP_DBOPTION

• Tim Riley-487603

  SSChasing Mays

  Points: 645

  More actions

  January 23, 2009 at 3:05 am

  #155166

  Sorry, maybe I missed it. Somewhere is there a list of all options and syntax for sp_dboption? :unsure:

  Tim

• Renuka__

  Hall of Fame

  Points: 3656

  More actions

  January 23, 2009 at 3:25 am

  #931709

  Hi,

  Check in BOL for all the options and syntax for sp_dboption. Links from MS here:

  http://msdn.microsoft.com/en-us/library/aa933268(SQL.80).aspx (SQL 2000)

  http://technet.microsoft.com/en-us/library/ms187310(SQL.90).aspx (SQL 2005)

  [font="Verdana"]Renuka__[/font]

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  January 23, 2009 at 6:29 am

  #931748

  Yep, right there in the BOL. I had to look it up just to verify.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning