November 9, 2007 at 3:03 am
Hi Experts,
I have read an article about trigger in sqlservercentral.com. It is saying that trigger can send SMS to our mobile phone. How to learn this magic ? Any magician available to learn this magic ? if anybody knows him let me know his address.:) Well, I was wondering about it. Is it possible?
karthik
November 9, 2007 at 8:23 am
Greetings. I had a similar situation recently where I was having mail sent through a trigger. I posted here, and the consensus was that sending mail within a trigger is a bad idea. What was proposed was to create an email staging table, and have the trigger populate that table with info from the inserted or deleted tables, then have a job run to email the records in the table. You would need your trigger to be able to create the to address, cc address, subject, message, and a delivery date, and any other fields you would need to suit the parameters of your mail procedure.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 20, 2007 at 6:04 am
Any inputs from any experts ?
karthik
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply