Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blocker
Yak Posting Veteran
89 Posts |
 Posted - 2010-01-07 : 03:53:27
|
| Good day..Is it possible to send sms via query to a certain person when one of his/her records in sql server was changed.?Thank you for giving time..God bless. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-07 : 04:03:17
|
| yup. but you dont need vb6. you can do this from sql server itself using a sql agent job.see below as an examplehttp://www.siccolo.com/Articles/SQLScripts/how-to-create-trigger-to-sms-email.html |
 |
|
|
blocker
Yak Posting Veteran
89 Posts |
Posted - 2010-01-07 : 20:05:10
|
| thank you very much..its really helpful..Working on it now.God bless.. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-08 : 02:43:33
|
| great..good luck |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2010-01-09 : 05:03:42
|
| You dont need a trigger. Use EITHER1. XMLHTTP post object in either classic asp or .net2. web services3. extended stored procedures4. SMPP object |
|
|
|
blocker
Yak Posting Veteran
89 Posts |
Posted - 2010-01-11 : 02:01:00
|
| ill try to research this four possibilities. Anyway, thank you guys very much. Hope i can solve this as soon as possible.God bless us. |
|
|
|
|
|
|
vb6 send sms when sql server table has changed dat