Solved

SQL Server 2000 - Help with simple trigger

Posted on 2013-01-26
2
314 Views
Last Modified: 2013-01-26
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
Comment
Question by:JElster
2 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38822165
If you search the web for such trigger code, you should find examples...
And if you have a specific problem, we can help.
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 400 total points
ID: 38823046
Here is one example from a member of this site:
Generic audit trail trigger
http://www.nigelrivett.net/SQLTriggers/AuditTrailTrigger.html
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now