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 |
|
akpaga
Constraint Violating Yak Guru
331 Posts |
 Posted - 2009-05-28 : 15:10:08
|
| Hi is there a way to send email if my table gets updated via a triggerwhere the mail body should contain old and new information .The mail should contain only information that is updated and this is where i am stuck because any field can be updated any time and thereis no standard rule for updating?Hope i am clear thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-28 : 15:15:03
|
| why do you need to do this from trigger? isnt it enough to capture this changes in a audit table and then send the details periodically through a mail. you could schedule this as a job in sql agent that executes periodically based on schedule set |
 |
|
|
|
|
|
Update Trigger to send mail