Send SMS on Mobile when any data insert in SQL table

I would prefer doing this using a sql agent job. Sending email from triggers is not a recommended option.

What you can do is have a table which will have a status bit to indicate whether data has changed in your main table. Then through the trigger you can set the status based on data modification.

Then schedule job to execute may every 15 mins (or convenient schedule) . Inside job check the status. If its set get required data and sed mail by calling sp_send_dbmail task.

see gateway domain details here. similarly you can set email address to make it text to mobiles

http://ift.tt/1xgydvu

---

Please Mark This As Answer if it solved your issue

Please Vote This As Helpful if it helps to solve your issue

Visakh

----------------------------

My Wiki User Page

My MSDN Page

My Personal Blog

My Facebook Page