SQL Parameters

• California

  SSCommitted

  Points: 1888

  More actions

  January 28, 2009 at 6:03 pm

  #130485

  I was wondering, where can i find SQL Server startup parameters on SQL2005 Server? This was very easy on SQL 2000 - you go to the properties of enterprise manager and then you could see the start up parameters?

  How do we get to this on SQL 2005? Appreciated if someone please share.'

  Thanks,

• ravikanth.

  Hall of Fame

  Points: 3452

  More actions

  January 28, 2009 at 6:12 pm

  #934348

  Here you go.

  Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager.

  select the SQL Server service that you want to set the startup parameters.

  right click and select "Properties"

  go to the "Advanced" tab

• Nikhil-843675

  SSC Eights!

  Points: 895

  More actions

  January 29, 2009 at 1:37 am

  #934442

  Hi

  you can get this from following script..

  go to qury analyser and run following

  print '********** Startup Options *********'

  exec master..xp_regenumvalues N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters'

  go

  print ''

  print ''