How to identify Installed SQL Server version and edition

 


--First way

SELECT SERVERPROPERTY('productversion') AS Version
     , SERVERPROPERTY ('productlevel') AS ServicePack
     , SERVERPROPERTY ('edition')   AS Edition

--Second way

SELECT @@VERSION AS SqlServerInfo

Advertisements