Write alerts (severity state 16+) and events to a table


  • I've been comfortable with enabling database mail on SQL Server 2005 SP3+ since they disabled the system from *receiving* emails, and it was great for sending out alerts.  This particular company is in a situation where they cannot enable Database Mail due to security restrictions, thus I have to write alerts to a table and have a stored procedure query it at a set interval.


    First issue I ran into, how the heck can I query events and alerts, and write it to a table in SQL Server?  Any links to show me where to query the relevant information would be very useful.  Thank you!



    5. října 2011 23:55

Všechny reakce