As described in script.
2011-11-22 (first published: 2008-03-19)
5,699 reads
Michael Lacy,
2010-08-05 (first published: 2009-11-25)
As described in script.
-- I found something interesting if you ever want to send multiple reports using sp_send_dbmail -- You have to first set the rowcount to 0 (zero). -- There can't be a space after the semi-colon that separates the full pathnames for the reports. SET ROWCOUNT 0 EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Your_Server_Profile', @recipients = 'recipient.1@xyz.com; recipient.2@xyz.com', @body = 'Reports 1 and 2 are attached', @file_attachments = 'C:\Report Folder\Report1.TXT;C:\Report Folder\Report2.TXT', @subject = 'Reports 1 and 2 are attached' ; -- I did not see anything about this in BOL
2011-11-22 (first published: 2008-03-19)
5,699 reads
This script was created to Identify Query string that is blocked and the one that is blocking with a datetime reference. These information is stored in a history table.It also sends a mail notification without using SQL Mail
2005-04-28 (first published: 2005-04-15)
1,152 reads
Two Method for Return the Count of Weekday between two date!
2004-09-30
283 reads
This stored proc notify the user(s) if the data/log file grew. When you execute it for the first time it will get the data/log files sizes and inserts in a table. Next time when you run the script if will compare the current size with the previous files size. This script must need sqlmail configured […]
2003-11-07
1,450 reads
A Procedure send Alert by E-Mail about allfiles with option "Restrict File Growth" ifavailable space less then 10%.
2003-02-24
306 reads