Search This Blog

Wednesday, April 21, 2010

SQL Query to find if SQL Server is clustered

Query to find Server is clustered
USE MASTER
GO

SELECT @@servername 'ServerName',
ServerType = CASE ServerProperty('IsClustered')
WHEN 1 THEN 'Cluster'
WHEN 0 THEN 'Standalone'
ELSE 'Unknown' END,
@@version 'Version',
LEFT(CAST(SERVERPROPERTY('ProductLevel') as varchar(10)), 3) AS Level,
getdate() 'Date'

No comments: