SQL Server Restart Notification

If you ever wanted to be notified by email when your SQL Servers are restarted, here is a script which will do just that using sp_procoption which sets stored procedures for autoexecution.   What it does: This script sets up a stored procedure in the master database. sp_procoption is used to configure the stored procedure […]

Read More »