TSQL to know if database mirroring is setup for both PRimary and secondary server

Question

Hi,

I have Database mirroring setup between two SQl 2005 servers (no witness). Using Tsql, I want to find if there is a user database on both primary and mirror server. I can use the following on mirror:

select * from sys.databases where state <>1 and database_id>4

What should i use for Primary server?

Any help?

Regards

Manjot

Answer 1

Use the dmvs associated with database mirroring

For example, sys.database_mirroring