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('...
That property refers to a failover cluster instance, where the instance itself can only run on one node at a time because the storage fails over with the resource group. That property is also exposed in SMO and the registry to help identify why a SQL service is stopped, which would be the case if that node did not own the resource.