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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement