Monday, March 19, 2012

Find startup parameters using QA

I have some startup parameters that i have added using the EM->
Properties->General->Startup Parameters
Is there a way i can run a query and see them using QA instead of using the
GUI . Using SQL 2000Hi Hassan,
Those parameters are stored in the registry, not in SQL Server itself. The
key they are stored is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters.
Replace the second MSSQLServer with the instance name if you use an
instance.
You can get these values with the undocumented extended procedure
xp_instance_regenumvalues :
EXEC xp_instance_regenumvalues N'HKEY_LOCAL_MACHINE',
N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters'
--
Jacco Schalkwijk
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OHb1eWmxDHA.1616@.TK2MSFTNGP11.phx.gbl...
> I have some startup parameters that i have added using the EM->
> Properties->General->Startup Parameters
> Is there a way i can run a query and see them using QA instead of using
the
> GUI . Using SQL 2000
>

No comments:

Post a Comment