Krasavita
SSC-Insane
Points: 23138
More actions
October 2, 2008 at 10:07 am
#154781
If record exists in table 1
then
send email to tom@yahoo.com with table1 data
end if
Daveee
SSCommitted
Points: 1600
October 2, 2008 at 10:40 am
#880081
Assuming you're on SQL 2005,
1. Set up database Mail in SSMS (this needs an SMTP server)
2. Run sp_send_dbmail in your stored proc
October 2, 2008 at 10:48 am
#880085
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply