Sending SMS/email from SQL Server with queued users

We need to send email/sms to users for notifying some changes in a table in the database.

There can be an issue of queuing.

So, we are thinking of using a windows service or SQL Server trigger.

1. Service can poll the database and send SMS / e-mai开发者_如何学编程l and delete notified rows

2. Send SMS/email and do same functionality from trigger

Your suggestions please.

---

Service broker?

• Push the details onto a queue from the trigger (or stored proc?)
• Some process reads these and sends the email/sms. This can be separate from SQL Server