Can you do a query to get the db names on a principal and a mirror that will compare them.
I have 2 SQL Farms and they are mirrored between he 2 farms, I was looking for a query that would let me do a comparison between all the databases on the Principal and all the DB's on The Mirror. My SP folks aren't so good at telling me when they create a new content. When I use the sp_help db it doesn't list any of the content db's that are on the mirror only the system db's. If I use the sys.databsses it doesn't show me the DB's I have that are in a read only state.