Tuesday, 3 January 2017

Check the Active Cluster Node

 SELECT srvname as InstanceName , (CONVERT(varchar(200), (SERVERPROPERTY('ComputerNamePhysicalNetBIOS')))) ActiveNode , GETDATE ( ) CurrentDate from sys.sysservers where srvid=0 

No comments:

Post a Comment