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


No comments:

Post a Comment

Amazon Contextual Product Ads

Popular Posts