The following is some SQL logic that will automatically configure SQL Database Mail AND send you an email alerts if your Database Mirroring status is anything but ‘Synchronized’.

Get acquainted with SQL Server configuration tasks so that you can configure a Database Engine instance to meet performance and availability requirements. When a database is deployed into production ...

Database Mail, a new addition to the SQL Server 2005 database engine, is as simple to use as it is useful. Destined to be the replacement for SQL Mail, Database Mail uses a Simple Mail Transfer ...