Hi All,

Microsoft introduced 2 DMV’s(Dynamic management view) for viewing sql services information and system registery information in sql server denali

SELECT *
FROM sys.dm_server_services

And for the registery information , we have another DMV

SELECT *
FROM sys.dm_server_registry

Reference : Pinal Dave(http://blog.sqlauthority.com)

Please check and let us know if you have any concerns on this.

Thanks for viewing.

Regards,

Chaitanya

Visit site: https://mssqlbuzz.wordpress.com

Send an Email : mssqlbuzz