Find Out Key Property Information about SQL Server Instance with SERVERPROPERTY

SQL Server provides very useful T-SQL to find out details about property information of SQL Server instance by querying SERVERPROPERTY. With this T-SQL you can find out information like Product Version, Server Name, Edition, Collation, License Type etc. You can refer below query for more details and execute on SQL Server Management Studio to get output.

SELECT
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ServerName') AS ServerName,
SERVERPROPERTY('ProductLevel') AS ProductLevel,
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('EditionId') AS EditionID,
SERVERPROPERTY('Collation') AS Collation,
SERVERPROPERTY('BuildClrVersion') AS BuildCLRVersion,
SERVERPROPERTY('EngineEdition') AS EngineEdition,
SERVERPROPERTY('ResourceVersion') AS ResourceVersion,
SERVERPROPERTY('MachineName') AS MachineName,
SERVERPROPERTY('LicenseType') AS LicenseType,
SERVERPROPERTY('IsClustered') AS IsClustered,
SERVERPROPERTY('ResourceLastUpdateDateTime') AS ResourceLastUpdateDateTime;
GO

You will get the output as below.

Right CLICK HERE and open Link in new tab to watch live practical.

Reference: Manzoor Siddiqui [www.SQLServerLog.com]