Solved

Audit of Database Changes

Posted on 2010-08-18
3
282 Views
Last Modified: 2012-06-21
Is there an easy way to see what fields have changed in a database.

I have an audit requirement that basically needs me to determine what changed

So when I do an update, I would ideally like to know what columns and fields changed

Something like

Name: Fred Fluntstone

changed to

Name: Fred Flintstone
0
Comment
Question by:Plucka
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 2

Expert Comment

by:j_coreil
ID: 33466055
Typically data auditing like this is very expensive in way one or another. For example, there are applications that sit on the database that will log every change to every column. These solutions are very resource expensive as well as $$.

What I've done in the past is understand from a business aspect what information is really needing to be audited and logged. After you identify the columns, write a trigger that either logs the change into an audit table or fires off an alert. Lastly, another option is to implement auditing at the entire database level.

It really just depends on what you requirements really are and what $$ you have to work with.
0
 
LVL 18

Author Comment

by:Plucka
ID: 33466102
Cost isn't really an issue, but the basic things I need to log are

date
time
user
description of event
database changes
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 33471020
Then you should take a look at CDC
http://msdn.microsoft.com/en-us/library/bb522489.aspx

However it does require that you have a licenced copy of the Enterprise Edition.
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

691 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