Determining the companion’s mode

Issue sp_companion without any options to display the mode the companion is currently in. For example:

sp_companion

Server 'MONEY1' is alive and cluster configured.
Server 'MONEY1' is configured for HA services.
Server 'MONEY1' is currently in ‘Symmetric normal’ mode.

MONEY1 is configured for symmetric failover and is running in normal companion mode.You can also use the @@cmpstate global variable to determine the mode. At the isql prompt, enter:

select @@cmpstate

The @@cmpstate global variable is not used in an non-high availabilty environment, and reports a value of -2.

**Table 4-1: *@@cmpstate* return values**
@@cmpstate	Companion mode
0	Single server
1	Reserved
2	Secondary normal
3	Secondary suspended
4	Secondary failover
5	Secondary failback
6	Reserved
7	Primary normal
8	Primary suspended
9	Primary failback
10	Reserved
11	Symmetric normal
12	Symmetric failover
13	Symmetric suspended
14	Symmetric failback
15	Reserved