Can someone please tell me how to alert or notify an operator when any of the SQL Server services become unavailable ? Are there any commands that can capture this information from the event logs and send out email alerts or is there a way to do this from SQL ? Are there any scripts or info available for this, to monitor availability of SQL Services ?
Thanks