Tag: sql server version

  • T-SQL script to Identify the SQL Server version and edition

    Execute below T-SQL Script to get the SQL Server version details.

    SELECT SERVERPROPERTY ('productversion') as ProductVersion,
SERVERPROPERTY ('productlevel') as Productlevel,
SERVERPROPERTY ('edition') as Edition

    Output:
    -Product version (for example, 10.0.1600.22)
    -Product level (for example, SP3)
    -Edition (for example, Development)

    SQL Server 2012 version number examples
    11.0.2316 SQL Server 2012 CU1
    11.0.2100.6 SQL Server 2012 RTM