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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need Help Creating Trigger

Status
Not open for further replies.

rmartes

MIS
Feb 25, 2002
5
US
I created a table based on another table, but need to create a trigger that will copy new inserts, updates or deletes into the new table.

Thanks

rmartes
 
The best way to do this is using replication, not writing triggers.
 
If replication is the way to go, please tell me how to do this. I am new and learning and any help is greatly appreciated. Just remember that everytime a DML is performed on table 1, table 2 will get an extact copy.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top