Posts

Showing posts from July, 2012

Microsoft SQL Server 2005/2008R2:Daily Send Mail for Disk Space Usage.

Image
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 transaction log. * Input: * Version Info:    * No.                 Author                            Date