Tuesday, January 6, 2015

How do you verify SQL Server is clustered or not ?

Run below anyone of scripts:

Select ServerProperty('ComputerNamePhysicalNetBIOS')
Go
Select 'IsClustered', SERVERPROPERTY('IsClustered')
Go
Select * FROM fn_virtualservernodes()
Go
Select @@VERSION
Go

No comments:

Post a Comment