Trigger to send email - t-sql

Hello,
i have one DB on a sql server, (express),
the DB has one stored procedure, how can i write a trigger to send email each time the procedure runs??
is there any settings or requirement other to the trigger syntax?
thanks
Nyana22Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
setting up & sending mail via dbmail:
www.databasejournal.com/features/mssql/article.php/3626056 
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>how can i write a trigger to send email each time the procedure runs??
you cannot have a trigger on "run" of a procedure. you should include the "send email" code in the procedure itself.
0
 
Nyana22Author Commented:
ok, thanks, i will add the code at the end of the procedure,
but i don't know this code, could you tell me a sample, or point me to an article, please?
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.