Check SQL Server failover cluster configuration mode using T SQL

On 13 Apr, 2015

T-SQL

By : Charith Silva

No Comments

Sometimes SQL developers want to put some logic into their T-Sql code to check the SQL Server failover cluster configuration mode . The SERVERPROPERTY() built in metadata system function can be used to identify the failover cluster configuration. SERVERPROPERTY() function with IsClustered Property will return “0” for Not Clustered mode and “1” for Clustered mode.

USE [master];
GO
SELECT CASE SERVERPROPERTY('IsClustered') 
WHEN 0 THEN 'Not Clustered mode'
WHEN 1 THEN 'Clustered' 
ELSE 'Unknown'
END as [SQL Server failover cluster mode]

USE [master];

SELECT CASE SERVERPROPERTY('IsClustered')

WHEN 0 THEN 'Not Clustered mode'

WHEN 1 THEN 'Clustered'

ELSE 'Unknown'

END as [SQL Server failover cluster mode]

Previous Post Next Post

About The Author

Charith Silva

Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development. He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.

Number of Posts : 87

All Posts by : Charith Silva