Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

example of email trigger?

Status
Not open for further replies.

psimon88

IS-IT--Management
Jul 21, 2005
66
US
Hello

I am very new to ADP files but have worked with MDB files for eight years. I'd like to know how to set up a basic email trigger if records are added to a table (dbo.VM_lEADS).

This is the MS template:

CREATE TRIGGER VM_Leads_Trigger1
ON dbo.VM_Leads
FOR /* INSERT, UPDATE, DELETE */
AS
/* IF UPDATE (column_name) ...*/

Any help would be appreciated.

Thanks.
ps
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top