Hi Varun

The script creates several different alerts. Alerts such as "Mirror Connection Lost" and "Principal Running Exposed" etc dont require thresholds, however, alerts such as "Unrestored Log Threshold" do.

The SP sp_dbmmonitorchangealert can be used to set these thresholds (1 database at a time), I left this out of the script as thresholds are really different, and vary based on business preference and your mirroring requirements.

However, if there is a demand for it, i will gladly extend the script to include these thresholds based on some variables in the script etc.

Regards

Jordon