Posts Tagged ‘Standard’

How to Identify your SQL Server Version and Edition

I was just updating the Software Asset Register at my company and to do so I had to look at all of the SQL Servers in the business and find out the version and importantly the edition (Standard vs. Enterprise).   

I’d always used:  SELECT @@VERSION but I came across a Microsoft article showing an alternative:  How to Identify your SQL Server Version and Edition that shows another method using the SERVERPROPERTY() function.  As an example, I used the following: 

SELECT SERVERPROPERTY(‘MachineName’)    AS MachineName,
       SERVERPROPERTY(‘ServerName’)     AS ServerName,
       SERVERPROPERTY(‘ProductVersion’) AS Version,
       SERVERPROPERTY(‘ProductLevel’)   AS Level,
       SERVERPROPERTY(‘Edition’)        AS Edition,
       SERVERPROPERTY(‘IsClustered’)    AS IsClustered,
       SERVERPROPERTY(‘Collation’)      AS DefaultCollation,
       SERVERPROPERTY(‘LicenseType’)    AS LicenseType,
       SERVERPROPERTY(‘NumLicenses’)    AS NumLicenses 

You can read more about the possibilities of that on the MSDN SERVERPROPERTY() page.