Connect to the instance of SQL Server, and then run the following query (this will work for all versions of SQL Server):
|
1 |
Select @@version |
The result form the query will look like the following.
Microsoft SQL Server 2008 (SP1) – 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
For version of SQL Server 2005 and newer you also can use the SERVERPROPERTY function to retrieve additional information. Executing the following will provide you with the SQL Server product version (i.e. 10.0.2531.0, product level (RTM) and edition information (i.e. Standard, Enterprise):
|
1 |
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') |
You can lookup the product version using the following table:
| 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 Service Pack 1 | 10.50.2500.0 |
| SQL Server 2008 R2 RTM | 10.50.1600.1 |
| 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 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 Service Pack 4 | 8.00.2039 |
| 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 |
Where to find information about the latest SQL Server builds use the following link: http://support.microsoft.com/default.aspx?scid=kb;EN-US;957826
