SQL Server Startup Parameters

How can i retrive 开发者_高级运维the SQL Server startup parameter using SQL Query?

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.