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

    Dotaz

  • 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