Question - How to send email alert when aotomatic failover occurs in in Sql-Server 2005. I mirrored my database using High Safety with Automatic Failover option?
Answer -
Setup a job on each server which contains code to send you an email.
Setup an alert on the SQL Agent which monitors for event Id 1480. When the event fires have it run the job.