473,320 Members | 1,957 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SQL Server tables auditing approach

I am dealing with 2 tables that have identical structure. First one is the main table, and I use the second one for auditing via trigger – it just holds the current condition before auditing.

Is there a better practice to audit data changes and what is it?

My data is delicate, but on the other side – I am not planning to update it too many times.
Nov 14 '13 #1
2 1273
Maybe a two table design can work for you. I suggest having one table to keep the transaction data (database, schema, date, app that triggered transaction, etc.) and another table to hold the record modifications, so you are able to undo them easily.

There is also a SQL Server Change Data Capture (CDC) feature you could use, as well as some commercial tools meant to deal with this.
Nov 14 '13 #2
ck9663
2,878 Expert 2GB
Don't forget to use transaction in your trigger so any unsuccessful update of your main table will be rolled back.

Good Luck!!!


~~ CK
Nov 14 '13 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Ezekiël | last post by:
Hello, I need some help with implenting the following: I recently migrated from access to sql server and i now i want to use maintainable permissions on my tables, views, etc. The access...
1
by: Douglas Lane | last post by:
I would appreciate any help with this. At my wit's end. I have an access front end linking to SQL Server tables on the back end. One of these linked tables had a subdatasheet to another of the...
0
by: kai | last post by:
Hi, I am going to create a Client/Server application using Access as front end and SQL Server as back end. Now I have two choices: 1. Create ADP application (use stored procedures and views in...
3
by: Sarah | last post by:
Hi I am using vb.net Is it possible to fetch data from foxpro tables (vfp8) and update tables in sql server 2000? The table structures of the foxpro tables are different from those in sql...
1
by: Vish | last post by:
Hi All, I am trying to insert a GUID generated in .NET into my SQL Server tables. I am inserting it into a column of type uniqueidentifier. The GUID generated by ..NET has lower case alphabets...
1
by: Mrozu | last post by:
Hi How do you develop applications with tables in SQL Server? I mean how do you copy tables to other computers? Do you make it by 'CREATE TABLE' SQL Query? With big tables (with many columns)...
6
by: tomlebold | last post by:
How do link SQL Server tables to a Access front end without having the dbo prefix? I have to change the name of many tables. For Examble: dbo_Customer to Customer.
1
by: tomlebold | last post by:
How do you prevent a user from linking an Access application to SQL Server tables?
8
by: brucedodds | last post by:
I've inherited an A2003 application with linked SQL Server 2000 tables in the back end, using the Microsoft SQL Server ODBC driver. We've set up a test SQL Server database. I'd like to automate...
6
by: dantebothermy | last post by:
I have an Access application for which I'm trying to put the data on SQL Server. The data got there fine, but I'm having a problem running the application. The application is a membership...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.