With SQL Server versions 2008R2 and 2012, you can access the registry to get the settings for the current instance of SQL Server. Here is how it works using the dynamic management view (DMV) called dm_server_registry.
SELECT registry_key, value_name, value_data FROM sys.dm_server_registry
From there you get get at all sorts of information about the current SQL Server instance. Give dm_server_registry a try.
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!