This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a script to find different SQL Server Properties like Hostname, Instance, Edition, Version, ProductType.
The DBA can use this script to find server properties for various SQL Servers.
You can also use this script to prepare a report for various SQL Servers and also easily compare the difference between those servers.
1 2 3 4 5 6 7 8 9 10 |
SELECT SERVERPROPERTY('MachineName') AS HostName ,SERVERPROPERTY('InstanceName') AS InstanceName ,SERVERPROPERTY('Edition') AS EditionInfo ,SERVERPROPERTY('ProductLevel') AS ProductType ,CASE SERVERPROPERTY('IsClustered') WHEN 1 THEN 'Clustered' ELSE 'StandAlone' END AS SQLServerType ,@@VERSION AS SQLServerVersion |