Database Experts:Microsoft SQL Server 2005/2008 R2:Get alert when SQL Server Service goes down
SQL Server Alert Message When Server Goes Down. It is very obvious to monitor our sql server database services.Sometimes when we are not on server to look the status of services but need to know its status about when it restarted or failed. One tricky way is to schedule on Database Jobs to monitor on it. For this purpose follow some small steps. 1.Create One Stored Procedure which calls when services restarted. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO /******************************************************************************/ /* Copyright: 2012 Database Experts * * Name : Archive: [SQL_Server_Restart_Mail] $ * Version : Revision: * Last Updated : Modtime: * Created By : $Author: Bhavesh Thakkar * M...