SQL 2005 Mirroring Monitoring

[Teledude]

Guys,

Need a quick and easy way to send a daily mail stating that all mirroring is intact and up to date across 7 instances and 100+ databases - best way?

 

[Little_Crow]

Are you asking how to check that the mirroring is working, or how to send an e-mail about it, or both?

I can't offer any help on the first one, but the best way to send an e-mail via a script is to use blat.

I use it for various alerts, very simple and works well.

 

[Teledude]

SQL has built in emailing so thats not an issue just want the best way to get a daily update basically of all our mirroring