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

Question

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!

 

 

Answer 1

SQL Agent  Alerting does not currently have the feature you  requested. Please report your feedback to https://connect.microsoft.com/SQLServer/Feedback

We can consider this feature enhancement in future releases of SQL Server

Thanks

Sethu  Srinivasan [MSFT]

http://blogs.msdn.com/sqlagent