SQL script to query version information

Created by Jeremy Burgess, Modified on Tue, 4 Feb at 12:14 PM by Jeremy Burgess

Symptoms

You need to examine which version and edition (e.g. Express, Standard) is running on a particular SQL server.

Cause

n/a

Resolution

SELECT  
    SERVERPROPERTY('productversion') as 'Product Version', 
    SERVERPROPERTY('productlevel') as 'Product Level',  
    SERVERPROPERTY('edition') as 'Product Edition',
    SERVERPROPERTY('buildclrversion') as 'CLR Version',
    SERVERPROPERTY('collation') as 'Default Collation',
    SERVERPROPERTY('instancename') as 'Instance',
    SERVERPROPERTY('lcid') as 'LCID',
    SERVERPROPERTY('servername') as 'Server Name'