You might want to check out the subscription model in the SQL Notification Services http://www.microsoft.com/sql/NS/