Geeks With Blogs
kazim mehdi
DECLARE @RegLoc VARCHAR(100)
select @RegLoc='SOFTWARE\Microsoft\Windows NT\CurrentVersion'

EXEC [master].[dbo].[xp_regread]    @rootkey='HKEY_LOCAL_MACHINE', 
                                    @key=@RegLoc, 
                                    @value_name='ProductName'

 

The above code will return the installed version of windows on which the current instance of Sql Server is running.

references:

http://www.mssqlcity.com/Articles/Undoc/UndocExtSP.htm

Posted on Thursday, September 8, 2011 9:52 AM Sql , Sql Server , Windows Registry | Back to top


Comments on this post: Reading Registry value using T-SQL

# re: Reading Registry value using T-SQL
Requesting Gravatar...
Thanks a lot. Now I know how to enter and clean my registry without any other help. Up until now I was using a clean registry program that did the job perfectly but I would really like to try out the manual way too. I have always enjoyed programming and I think this is programming at its best.
Left by Neil on Nov 14, 2011 12:37 PM

Your comment:
 (will show your gravatar)


Copyright © kazim sardar mehdi | Powered by: GeeksWithBlogs.net