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 |
|
gint3232
Starting Member
2 Posts |
 Posted - 2008-01-19 : 16:59:24
|
| how do you get a trigger to email me or notify me when say a count of something does not match a count of some thing else, I am using web services to transfer records from one db to another db (some distance away) trouble is the web services don't always transfer so i need a way of counting like for like ...ie 43 recodrs here 43 record there...using SP's for inserts and triggers for counting |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-01-19 : 19:27:13
|
| I highly recommend you do NOT use the trigger to directly send the e-mail. The scope of the trigger should be limited to the database itself.Instead, use the trigger to populate a table with a queue of messages to be delivered. Then use a scheduled job to check the table for new messages and send the appropriate e-mails.e4 d5 xd5 Nf6 |
 |
|
|
|
|
|
triggers