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 |
|
rajusvs
Starting Member
9 Posts |
 Posted - 2001-12-18 : 12:55:52
|
| Is there any way we can send a mail form a trigger or sp.Thanks |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2001-12-18 : 13:56:35
|
If you aren't going to be sending a lot of mail, check out xp_sendmail in BOL. And if you want something more robust (or just want to do it right  ), check out this article: http://sqlteam.com/item.asp?ItemID=5003Edited by - izaltsman on 12/18/2001 13:58:55 |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2001-12-18 : 17:08:41
|
| HiActually, from a trigger, if you want it to be quick, I would look at something like thishttp://sqlteam.com/item.asp?ItemID=5908All your trigger has to do is insert a record into a table, and your job will handle the mail sending.Damian |
|
|
|
|
|
|
Sending a mail from a trigger