Microsoft SQL Server 2005/2008R2:Daily Send Mail for Disk Space Usage.
Read this document for getting knowledge of Database Mail . First need to create Database Mail Server. 2nd thing to Create Stored Procedure to Mail Disk Usage Space. 3rd thing to Schedule this procedure. 1.Create Database Mail Server. Right Click on Management-->Database Mail Click on Add. Test Database Mail. Check Mail For Confirmation. 2.Create Stored Procedure to DiskUsageMail. USE [master] GO /******************************************************************************/ /* Copyright: 2012 Database Experts * * Name : [DiskUsageMail]$ * Version : $Revision: 1 * Last Updated : $Modtime: * Created By : $Author: Bhavesh Thakkar * Modified By : $Author: * Script : This procedure is used to Shrink Database transa...