Sunday, October 3, 2021

Information about SQL Server version

 Try using below sql script to find the detail information about SQL server Version.

SELECT SERVERPROPERTY('MachineName') AS Host,
    SERVERPROPERTY('InstanceName') AS Instance,
    DB_NAME() AS DatabaseContext,
    SERVERPROPERTY('Edition') AS Edition,
    SERVERPROPERTY('ProductLevel') AS ProductLevel,
    CASE SERVERPROPERTY('IsClustered')
        WHEN 1 THEN 'CLUSTERED'
    ELSE 'STANDALONE' END AS ServerType,
@@VERSION AS VersionNumber;

Output:




No comments:

Post a Comment