Is there a way to setup a notification within SQL Server when a shutdown or terminate is requested, in process, going to occur...anything? I see the events in sys.messages, and setup alerts for notification, but the alert isn't sent out, I am assuming
because a shutdown or failover is in progress so alerting is stopped?? Just my thought, but I want to just send an email to a group saying "<SQL Server Shutdown In Progress>" or something, so we have a heads up. We currently have a cluster that fails
over to another node (out of sequence) and we don't really find out unless we go look. We have no 3rd party tool for this atm.
John M. Couch
View Complete Post