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.
2010-08-05 (first published: 2009-11-25)
6,946 reads