Tracking Changes to DB

[CementCarver]

I've been asked by my client to investigate if it's possible to track changes to a database and to record which user made these changes.
Can anyone guide me to some reference material so that I may investigate this?

CementCarver

[pbaldy]

Presuming you mean changes to data, search on audit trail methods. Here's one:

http://allenbrowne.com/AppAudit.html

[CementCarver]

That's excellent. thx

[pbaldy]

No problem, and welcome to the site by the way!