if a principal server suddenly fails, if the mirror server has confirmation from the witness, it can automatically take on the role of principal and make its database available within a few seconds.Then that time i should get the alert mail.

For that i am preparing monitoring storedprocedure.

It means if i excute that sp then i should get the mail alert.

I am not able to implement this logic in that sp.

any help pls..........