(If principle database gows down then mirror database takes the charge.

Then that time i want to get the alert message with both databases status.)

I need the sp for this(using above logic).I am using dbmail.