SERVERPROPERTY

SQL SERVERPROPERTY

SERVERPROPERTY is a system function. SERVERPROPERTY provides information about your SQL Server like edition, InstanceName, Product Version, ServerName etc.

SERVERPROPERTY Example

The following query will return the Product Version, Product Level, Server Name, Instance Name and Edition.

SELECT
    SERVERPROPERTY('ProductVersion') AS ProductVersion,
    SERVERPROPERTY('ProductLevel') AS ProductLevel,
    SERVERPROPERTY('ServerName') AS ServerName,
    SERVERPROPERTY('InstanceName') AS InstanceName,
    SERVERPROPERTY('Edition') AS Edition;
GO

For more on SERVERPROPERTY see here.