How to know version and edition of my SQL Server

To know a version and edition of MS SQL Server it is recommended to execute there the following command:

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

It should work for all currently existing versions of SQL Server starting from 2000. If you face any problems with the offered way you can have a look at the following article from Microsoft knowledge base: http://support.microsoft.com/kb/321185/en

Add Feedback