Dear Friends
How can i retrive the SQL Server startup parameter using SQL Query?? Plz help me
Thanks in advance
+1
A:
Check This. It might help you.
The lines below is of your interest.
$startupParameters = $wmiserver.Services['MSSQLSERVER'].StartupParameters # YMMV on the service name if you use named instances
$mtlSetting = $startupParameters.split(';') | ? { $_.StartsWith('-g'
You can use CLR Stored proc to use WMI. Here is a tutorial.
Manjoor
2010-07-15 08:02:16
i want to Retrive the SQL server Startup parameter.
John
2010-07-15 08:04:38
The blogpost do the same first retriev then modify it. It is a WMI script so you need to convert it to your language of choice. If you want to read it into a SP, i don't know if it is possible.
Manjoor
2010-07-15 08:15:57
In SP you can use CLR
Manjoor
2010-07-15 08:21:51