USE Master
GO

SELECT	M.mirroring_partner_name,
		M.mirroring_role_desc,
		M.mirroring_state_desc,
		D.state_desc
FROM	sys.database_mirroring M
JOIN	sys.databases D
ON		M.database_id = D.database_id
WHERE	mirroring_role_desc IS NOT NULL