SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Errorlog Notification

By Shas3,

This script Notifies the user(s) whenever there is an Error logged in the Error message.

It excludes the Error messages 15457 and 1073759806. These 2 Errors can be ignored. (I know we like to keep our Elogs clean but for some time you need to yield to them J ). You’ll see the first error when you check the Server props in the EM and other is when you start the sql mail manually.

This script assumes that you already configured SQL MAIL.

This script creates 2 tables and a temp table. Usually I create all my monitoring scripts in one database (DBADMIN) that makes my things to keep simple and easy. So I will leave the decision to you folks, if you don’t want create database (DBADMIN) replace the database name with your database name.

Total article views: 1180 | Views in the last 30 days: 10
Related Articles

Create Login Script

Error with Create Login Script


Script to send database consistancy errors

This script will run consistency check on database and send an email notification if it found any co...


script errors

script errors


Create SCHEMA error

Error when running script to create schema


Database Snapshot Create/Drop/Restore SQL Script.

Database Snapshot Creat/Drop/Restore SQL Script for Single or multiple data files of databases.