Find out which version of SQL Server 2005 or 2008 is installed in the machine

January 2011
M	T	W	T	F	S	S
« Apr		Feb »
	1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30
31

Posted by Swetha Sankaran on January 12, 2011

So, blogging after a super long hibernation. Good to be back!
I was trying to install SP3 for SQL Server 2005 and it kept failing on me. Got so frustrated until I found this nifty little query that does just that. Gives the version of SQL Server installed.
Here it is!
SELECT @@VERSION
GO

SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

So there ya go!
For further info see http://support.microsoft.com/kb/933508
Have fun!

Like this:

Be the first to like this post.

This entry was posted on January 12, 2011 at 4:41 PM and is filed under SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.