useful things about data, databases, data warehouse and related stuff. The opinions expressed in this blog are mine alone. They may not necessarily reflect that of my employers and customers - both past or present. The comments left by the reviewers are theirs alone and may not reflect my opinion whether implied or not. None of the advice is warranted to be free of errors and omission. Please use at your own risk and after thorough testing in your environment.
Monday, April 16, 2012
Find if SQL Server is clustered and which is the active node
SERVERPROPERTY('IsClustered') as _1_Means_Clustered ,
SERVERPROPERTY('Edition') as Edition ,
SERVERPROPERTY('ProductVersion') as Version ,
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as ActiveNode