Execute Script on Mirror Failover

Hi All
Is it possible to automatically execute a script when a mirror server fails
over to the secondary server?
ThanksPerhaps having an EVENT NOTIFICATION on the DATABASE_MIRRORING_STATE_CHANGE
event, and activation on
that Broker queue?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"David" <David@.discussions.microsoft.com> wrote in message
news:EB1E80D6-6F64-4061-8D19-9639CBBD5A31@.microsoft.com...
> Hi All
> Is it possible to automatically execute a script when a mirror server fail
s
> over to the secondary server?
> Thanks