Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script out all alerts Expand / Collapse
Author
Message
Posted Thursday, May 15, 2014 5:15 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 2:55 AM
Points: 1,466, Visits: 3,036
Comments posted to this topic are about the item Script out all alerts

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists
Post #1571554
Posted Tuesday, September 23, 2014 9:28 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 9:45 AM
Points: 893, Visits: 2,477
Thank you for the script, Carolyn; both sets of SQL Statements (the alerts and the notifications) work well on SQL 2012, both on error number and severity level based alerts.

One note to any users is that while the generated scripts do check for any sysalert of the same name, they do not check for any alert on the same condition, which results in an error if the script attempts to put a sysalert of a different name on a condition that a given server already has a differently named alert for.
Post #1618900
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse