Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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