How to check the version of SQL Server currently running on our instance?


Usually I visit the MSDN forums on a daily basis. One of the common questions which I found in the forum is How to check the version of SQL Server currently running on our instance? There is an article in the Ms Support website, which describes this in great details. In this post, we are going to discuss about a T-SQL query, which will give us all the required information.  The query is as follows:

— Find out the SQL Server Edition, Service Packs Applied and Version Number

SELECT SERVERPROPERTY(‘Edition’) as [SQL Server Edition],

       SERVERPROPERTY(‘ProductVersion’) as [SQL Server Version],

       SERVERPROPERTY(‘ProductLevel’) as [Applied Service Packs Version]

GO

The above query gives us all the required information.

I am reading Kalen Delaney’s Microsoft SQL Server 2008 Internals. In the first chapter, I got an additional ServerProperty: EngineEdition. So the above script is modified as given below:

SELECT SERVERPROPERTY(‘Edition’) as [SQL Server Edition],

       SERVERPROPERTY(‘ProductVersion’) as [SQL Server Version],

       SERVERPROPERTY(‘ProductLevel’) as [Applied Service Packs Version],

       SERVERPROPERTY(‘EngineEdition’) as [SQL Server DB Engine Edition]

GO

For more information, please visit the following page on Microsoft Support website: http://support.microsoft.com/kb/321185

Advertisements

About Sudeepta Ganguly

A SQL Server User... Still Learning
This entry was posted in SQL Server Versions. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s