How to identify your SQL Server version and edition
To determine the SQL Server edition, version and service pack installed on your SQL Server, connect to your server and execute one the following commands.
If you are not sure which edition of SQL Server you are running then SELECT @@Version should return you some information.
SQL Server 2005
To determine the which exact version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
SQL Server 2000
To determine which version of SQL Server 2000 is running, connect to SQL Server 2000 by using Query Analyzer, and then run the following code:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
The results from 2000 & 2005 looks like:
9.00.1399.06 RTM Enterprise Edition
- The product version (for example, 9.00.1399.06).
- The product level (for example, "RTM" or "SP2").
- The edition (for example, "Standard Edition").
SQL Server 7 & SQL Server 6.5
To determine which version of Microsoft SQL Server 7 & 6.5 is running, connect to SQL Server 6.5 and then run the following command:
SELECT @@VERSION