Skip to content

How to identify version and Edition of SQL Server ?

February 14, 2013

In this article I have covered some of the key methods of detecting SQL Server version and Edition.

Method1 : An easy way to find out SQL version is to use version command.
Use below query

Select @@VERSION
go
SELECT SERVERPROPERTY('productversion')

Screenshot:

SQL SERVER Version1

 

 

 

Method 2: Version can easily be found in SQL Server Agent logs, simply search for version in current log file. Whenever SQL Server Services are restarted an entry of version is written into logs.

Screenshot:

SQL SERVER Version2

Method 3: SQL Server Discovery report: Starting SQL Server 2008 you can use this report to determine version of SQL Server. To open this report follows below steps:

All programs  SQL Server → Configuration Tools →  SQL Server Installation  Centre → Under Tools → Select Installed SQL Server feature discovery report.

SQL SERVER Version3

 

 

 

Based on version number you can determine Edition and Service pack installed. The following table lists the major SQL Server releases.

SQL Server 2012 version information

Release

Product Version

SQL Server 2012 Service Pack 1

11.00.3000.00

SQL Server 2012 RTM

11.00.2100.60

SQL Server 2008 R2 version information

Release

Product version

SQL Server 2008 R2 Service Pack 2

10.50.4000.0

SQL Server 2008 R2 Service Pack 1

10.50.2500.0

SQL Server 2008 R2 RTM

10.50.1600.1

SQL Server 2008 version information

Release

Product version

SQL Server 2008 Service Pack 3

10.00.5500.00

SQL Server 2008 Service Pack 2

10.00.4000.00

SQL Server 2008 Service Pack 1

10.00.2531.00

SQL Server 2008 RTM

10.00.1600.22

SQL Server 2005 version information

Release

Product version

SQL Server 2005 Service Pack 4

9.00.5000.00

SQL Server 2005 Service Pack 3

9.00.4035

SQL Server 2005 Service Pack 2

9.00.3042

SQL Server 2005 Service Pack 1

9.00.2047

SQL Server 2005 RTM

9.00.1399

SQL Server 2000 version information

Release

Product version

SQL Server 2000 Service Pack 4

8.00.2039

SQL Server 2000 Service Pack 3

8.00.760

SQL Server 2000 Service Pack 3

8.00.760

SQL Server 2000 Service Pack 2

8.00.534

SQL Server 2000 Service Pack 1

8.00.384

SQL Server 2000 RTM

8.00.194

Advertisements
No comments yet

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

%d bloggers like this: