Don’t you hate it when you are the last one to know about any type of replication error(s)? I mean, you are the bloody DBA for crying out loud. Shouldn’t you be on top of the game?
The attached script will alert you when there are any errors in replication in the last 5 minutes. You can change this value to every one minute if you so desire. It takes one parameter, @servername. From there, it makes a call to the pass-thru server via linked server, and will then do its thing.
This script is NOT suppose to be applied directly to the replication server(s). You have to apply it elsewhere. The reason for this is that you don’t want any type of additional bottleneck on the server.
If there is/are any error(s) within the last 5 minutes, an email will be sent to you.
