THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Tamarick Hill

July, the 31 Days of SQL Server DMO’s – Day 30 (sys.dm_server_registry)

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

image

View using RegEdit to view the registy:

image

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

Published Tuesday, July 30, 2013 10:59 AM by Tamarick Hill

Comments

No Comments
New Comments to this post are disabled
Privacy Statement