Checked out SQL Notification Services?
Well the feedback I've had to date has been that this is a technical site so keep it mostly techinical....
To that end, you've probably all heard about SQL Reporting services - the report writer that can be scheduled to run as a SQL job and scale to meet the most demanding scheduled report requirements. The SQL Server team released this Yukon feature early because...well it was ready! But for my money, SQL Notification services, released some months ago now, is worth just as much airlplay.
Sick of writing your own notification agents or triggers? see if this free add-on to SQL Server could do the trick for you!
