Posts

Showing posts from October 9, 2012

Database Experts:Microsoft SQL Server 2005/2008 R2:Get alert when SQL Server Service goes down

Image
 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  * Modified By   :    * Script      : This Procedure is developed for Email When SQL Server Restart.  * Input: Nothing  * Output: Nothing  * Version Info:      *   No.   Author   Date    Comments      *   --