问确定SQL故障转移群集中的活动节点

EN

Select ServerProperty('ComputerNamePhysicalNetBIOS')

SELECT * FROM fn_virtualservernodes();

SELECT * FROM sys.dm_os_cluster_nodes; 

IF EXISTS (SELECT ars.role FROM sys.dm_hadr_availability_replica_states ars JOIN sys.availability_groups ag ON ars.group_id = ag.group_id WHERE ars.role_desc = 'PRIMARY')
    BEGIN
        SELECT 'PRIMARY' -- DO STUFF IF PRIMARY
    END
ELSE
    BEGIN
        SELECT 'NOT PRIMARY' --- DON'T DO STUFF
    END