Identify the SQL Server version and edition

Identify the SQL Server version and edition

To determine which version of Microsoft SQL Server is running, connect to SQL Server by using SQL Server Management Studio, and then run the following Transact-SQL statement:

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

The following results are returned:
-The product version (for example, 10.0.1600.22)
-The product level (for example, RTM)
-The edition (for example, Enterprise)

SQL Server 2008 version number examples:
-RTM: 10.0.1600.*
-SP1: 10.0.2531.*

SQL Server 2005 version number examples:
-RTM: 9.0.1399.*
-SP1: 9.0.2047.*
-SP2: 9.0.3042.*
-SP3: 9.0.4035.*

SQL Server 2000 version number examples:
-RTM: 8.0.194.*
-SP1: 8.0.384.*
-SP2: 8.0.534.*
-SP3: 8.0.760.0
-SP3a: 8.0.760.*
-SP4: 8.0.2039.*