By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,481 Members | 1,211 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,481 IT Pros & Developers. It's quick & easy.

need assistance with database mail, sp_send_dbmail

P: 1
In SQL Server 2005 I have database mail, I need experienced assistance with a project- when a new record is created send an html message to the new records column "Authorize" , for example jerry@icusoftware.com
please email me jerry@icusoftware.com w price
Feb 7 '08 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
In SQL Server 2005 I have database mail, I need experienced assistance with a project- when a new record is created send an html message to the new records column "Authorize" , for example jerry@icusoftware.com
please email me jerry@icusoftware.com w price
1, read this
2. create an trigger on your table
Feb 8 '08 #2

ck9663
Expert 2.5K+
P: 2,878
In SQL Server 2005 I have database mail, I need experienced assistance with a project- when a new record is created send an html message to the new records column "Authorize" , for example jerry@icusoftware.com
please email me jerry@icusoftware.com w price
1, read this
2. create an INSERT trigger on your table.
3. every time an insert is done, run the email proc (see 1)

-- ck
Feb 8 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.