SQL Server Performance Forum – Threads Archive

Sending SMS

How can we send SMS for DML operations?

---

I am not sure there and DML operations for SMS. but there are thrid party tools —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

True and with SMTP you can achieve but again Triggers involvement will be there, which are like performance degradation on a large scale usage. If you can be specific your requirement about frequency of the messaging then something can be achieved. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

Can you tell us why is the main reason to send SMS for DML operations… if the db is active you get thousands of them… If you want to do for perticular table…you can follow Satya’s recomendation but don’t use send mail task in a trigger …
you can write to audit table with additional column modified data and write a procedure to check the table and send SMS/mail as needed based on modified date… MohammedU.
Moderator
SQL-Server-Performance.com

---

]]>