Determining the Mode with @@cmpstate

You can also determine the mode using the @@cmpstate global variable. At the isql prompt, enter:

select @@cmpstate

Table 4-1 describes values that @@cmpstate returns:

**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