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!