Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

SQL Server 2000 - Help with simple trigger

Hi..
I need a simple trigger to log all changes to a CUSTOMERS table.
I want to crate a a table call CUSTOMERS_LOG  (copy of Customers table) and log the ALL the fields and changes - Maybe include a field for Insert, Update , Delete with a timestamp.

thx
0
JElster
Asked:
JElster
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
If you search the web for such trigger code, you should find examples...
And if you have a specific problem, we can help.
0
 
Anthony PerkinsCommented:
Here is one example from a member of this site:
Generic audit trail trigger
http://www.nigelrivett.net/SQLTriggers/AuditTrailTrigger.html
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now