I have 2005 mirroring working fine with a 3rd witness server. but I don't see
how to alert from Mirroring Monitor running on the witness. A technet article
goes into great detail about sys.sp_dbmmonitoraddmonitoring and other related
stored procedures but they seem to run off a hidden system table for the
monitored database that is not being created on my witness - presumably
because Mirroring Monitor is being run on a witness that does not have a copy
of the monitored database.
So how do I request mirroring states on a witness machine so I can alert
from the Witness when states change?
Thanks

Bill