Forum Discussion
SERVERPROPERTY('IsClustered') does not return the correct value in a cluster configuration
Hi all! I'm testing some t-sql SQL properties for a data collection project and I got a strange case with the query below: SELECT SERVERPROPERTY(''MachineName') AS [MachineName], SERVERPROPERTY('...
For Availability groups, the equivalent server property is "IsHadrEnabled".
See SERVERPROPERTY (Transact-SQL) - SQL Server | Microsoft Learn for all serverproperties and their descriptions.