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:
Follow me on Twitter @PrimeTimeDBA