Audit of Database Changes

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
LVL 18
PluckaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

j_coreilCommented:
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
PluckaAuthor Commented:
Cost isn't really an issue, but the basic things I need to log are

date
time
user
description of event
database changes
0
Anthony PerkinsCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.