How do I display new V12 MirrorServerState property?

[Breck_Carter]

In a functioning V12 HA setup, the following queries consistently show MirrorServerState as NULL:

-- On primary...

SELECT DB_PROPERTY ( 'MirrorRole' ) AS a, 
       DB_PROPERTY ( 'MirrorServerState' ) AS b,  
       DB_EXTENDED_PROPERTY ( 'MirrorServerState' ) AS c, 
       DB_PROPERTY ( 'MirrorServerWaits' ) AS d, 
       DB_PROPERTY ( 'MirrorState' ) AS e;

a,b,c,d,e
'primary',,,'0','synchronized'

-- On secondary (mirror)...

SELECT DB_PROPERTY ( 'MirrorRole' ) AS a, 
       DB_PROPERTY ( 'MirrorServerState' ) AS b,  
       DB_EXTENDED_PROPERTY ( 'MirrorServerState' ) AS c, 
       DB_PROPERTY ( 'MirrorServerWaits' ) AS d, 
       DB_PROPERTY ( 'MirrorState' ) AS e;

a,b,c,d,e
'mirror',,,'0','synchronized'

[graeme_perrow]

The second parameter to db_extended_property should be the name of a server, and the property value will indicate the state of that server.

See the docs on db_extended_property (Note: bit.ly redirect to dcx.sybase.com)