The sys.dm_server_registry DMV is used to provide SQL Server configuration and installation information that is currently stored in your Windows Registry. It is a very simple DMV that returns only three columns. The first column returned is the registry_key. The second column returned is the value_name which is the name of the actual registry key value. The third and final column returned is the value_data which is the value of the registry key data. Lets have a look at the information this DMV returns as well as some key values from the Windows Registy.

SELECT * FROM sys.dm_server_registry

View using RegEdit to view the registy:

This DMV provides you with a quick and easy way to view SQL Server Instance registry values.

For more information about this DMV, please see the below Books Online link:

http://msdn.microsoft.com/en-us/library/hh204561.aspx

Follow me on Twitter @PrimeTimeDBA