How to determine the version and edition of SQL Server and its components

 

KB321185 explains a number of different methods to determine the version and edition (Developer, Standard, Enterprise,…) of SQL Server. The easiest in my opinion is method 4:

Connect to the instance of SQL Server, and then run the following query:

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

Technorati Tags: SQLServer,Microsoft,administration