How To Find Out your SQL Server Build Numbers

Jan 19

Written by:
Saturday, January 19, 2013 9:04 AM  RssIcon

Each different Version of a SQL Server has it’s own Build number.

In the following table, you can find all the Versions from SQL 2000 RTM to SQL 2012 SP1

Otey sql server build version table 1

For a complete list of all SQL Server Builds with their release date / download links (for SP’s and CU’s)  and other information, check the SQL Server Builds Blogspot.

 

The SQL Server Management Studio is the tool to find out your current version

image

When you open the Query Editor and run one of the following T-SQL queries, you get the current SQL Server version:

SELECT @@VERSION

or

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

 

You will get the following result:

image