<< 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 !!!

 

posted @ Wednesday, May 20, 2009 5:20 PM

Print

Comments on this entry:

No comments posted yet.

Your comment:



 (will not be displayed)


 
 
 
 
 

Live Comment Preview:

 
«November»
SunMonTueWedThuFriSat
25262728293031
1234567
891011121314
15161718192021
22232425262728
293012345






ASP.NET

Promote Your Page Too

About
Twitter











Archives
Post Categories
Blogs I read
Syndication:

RSS ATOM