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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-25 : 13:13:48
|
Phil writes "I am trying to create a trigger with SQL 7 that will look at a database and when a column like status is updated from open to closed it will email the supervisor that the employee's report it done. I know you have to use like xp_sendmail and such but I'm not sure how to get the variables into it. Such as having a field on another table with the immediate supervisor (imd_sup) and have it know to send the email to that person and have it coming from the person that created the report. Any help or tips would be greatly appreciated, thanks a lot!
Phil" |
|
|
|
|
|
Trigger to send Email notification