Since SQL Mail periodically stops working and the simple
fix is to stop and start it, this script does just that.
It can be scheduled to run as a task as often as desired
using an ISQL command (e.g. isql -U sa -P -i "e:\dba\mailstopstart.sql" -o "e:\dba\mailstopstart.out")
or as a stored procedure. It has been tested on SQL 6.5 and SQL 7.0 servers.
master..xp_stopmail go waitfor delay '0:00:05' go master..xp_startmail go
2010-08-05 (first published: 2009-11-25)
6,646 reads
2011-11-22 (first published: 2008-03-19)
5,804 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,162 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,469 reads
