How to identify SQL Server version and edition?
Use below procedure to Identify SQL Server version and edition quickly:
Step 1: Execute below query after connecting to the SQL Server instance whose version and edition is required to be identified.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
This query will directly return below information:
Product version: Version of SQL Server (This will be a numeric value describing exact version)
Product Level: Product Level of SQL Server (For example RTM, SP1 etc)
Product Edition: Edition of SQL Server (For example
, Standard etc) Enterprise
Step 2: Your result from the query of Step 1 will give you the details of SQL Server Version, Edition and Product Level. However as version is returned in numeric format, please follow below rule of thumb to identify SQL Server’s major version:
If it starts with 10. then it is SQL Server 2008 (eg. 10.0.1600.22 is SQL 2008 EE RTM)
If it starts with 9. then it is SQL Server 2005
If it starts with 8. then it is SQL Server 2000
If it starts with 7. then it is SQL Server 7
If it starts with 6. then it is SQL Server 6.5
Service pack level and edition will be returned in plain English only.
This version number is incremented with each update of SQL Server and disclose the exact version of SQL Server we are using (including even the hotfix level etc). Please refer to http://support.microsoft.com/kb/321185 if you are interested for more detailed explanation on the version number.