need assistance with database mail, sp_send_dbmail

[quack]

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@icusoftwa re.com
please email me jerry@icusoftwa re.com w price

[ck9663]

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@icusoftwa re.com
please email me jerry@icusoftwa re.com w price

1, read this
2. create an trigger on your table

[ck9663]

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@icusoftwa re.com
please email me jerry@icusoftwa re.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