<< Some important links | Home | Error: Could not load file or assembly 'System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The module was expected to contain an assembly manifest. >>

Finding installed version, edition and service pack version of SQL Server

Today I wanted to find the version of SQL Server 2008 installed in my machine.  I did a quick search and the first support article from Microsoft had the answer to it http://support.microsoft.com/kb/321185

I just modified it a little bit with column headings so that if you are using it in an SP, returning it etc., it would help.  So the modified query is as below

SELECT SERVERPROPERTY('productversion') as 'Product Version', SERVERPROPERTY ('productlevel') as 'Service Pack Version', SERVERPROPERTY ('edition') as Edition

If there are better/alternate ways, please post in the comments.

Cheers !!!

 

Print | posted on Wednesday, May 20, 2009 5:20 PM

Comments on this post

# re: Finding installed version, edition and service pack version of SQL Server

Requesting Gravatar...
alIN GÜZEL
Left by meksika biberi zayıflama hapı on May 31, 2010 11:06 PM

Your comment:

 (will show your gravatar)