Hello Jordon,

I have read your article and reviewed your script (thank you for creating it), and the MSDN/Technet articles used as source.

I have a comment and a question about Alerts relating to Error Numbers 32040, 32042, 32043 and 32044:

Comment

Your script assumes that Error Numbers 32040, 32042, 32043 and 32044 are already being written to the SQL Server Log.

If not, this can be accomplished using [font="Courier New"]sp_altermessage[/font]:

/* Unsent Log Threshold [font="Courier New"](http://msdn.microsoft.com/en-us/library/aa337325.aspx)[/font] */

sp_altermessage 32042, 'WITH_LOG', TRUE

Question

With respect to the Unsent Log Threshold (Error Number 32042) Alert defined for a specific database, are you able to cause the Alert to occur? Testing I have completed to date seems to indicate that Threshold Alerts need to be defined for the <all databases> Database Name rather than a single named database. If you were successful, I would appreciate if you update this article with the actions you took to cause Threshold Alerts to occur for an individual database.

Thank you.

David