up vote 0 down vote favorite
share [g+] share [fb]

How can I check from the registry which Microsoft SQL Server(2000,2005 or 2008) is installed in my computer?

link|improve this question
feedback

2 Answers

up vote 0 down vote accepted

Under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft you should see subkeys in the left side pertaining to installed versions of SQL Server. I have Microsoft SQL Server 2008 as shown below:

alt text

link|improve this answer
I cant see the registry enties you wanted to show. Can u please edit it...I wanted to check it with my entries – Pia Jan 8 '10 at 10:20
Inside there should be a version key which will tell you. – John T Jan 8 '10 at 10:39
feedback
up vote 0 down vote

You want to avoid using the Registry, and use SELECT @@VERSION from a SQL query.

In the Registry, under HKLM\Microsoft\Microsoft SQL Server there are some keys and entries in there, but not as helpful as SELECT @@VERSION.

link|improve this answer
Agreed but actually I want to know it from a Registry only...I got it...in HKLM\Microsoft\Microsoft SQL Server\MSSQL.n\Setup, entry called Version is what I was looking for. – Pia Jan 8 '10 at 10:28
feedback

Your Answer

 
or
required, but never shown