DMV to get SQL Server Registry information


SQL Server 2012 has new DMV sys.dm_server_srvices
This provides details in registry related to SQL server

This provides some interesting information like 
SQL Server Version/Startup Parameters/Ports/Service startup options

SELECT *
FROM   sys.dm_server_registry

Leave a comment


Design a site like this with WordPress.com
Get started