Geeks With Blogs
kazim mehdi
select @RegLoc='SOFTWARE\Microsoft\Windows NT\CurrentVersion'

EXEC [master].[dbo].[xp_regread]    @rootkey='HKEY_LOCAL_MACHINE', 


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


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: