Auditing - Update Records 1

[puitar]

Greets,

I'm new to SQL Server. I know SQL Server has some auditing features. Does this include storing information about record updates/additions/deletions? I want to store the following info...

Time and date record was updated, all row data before update was completed, users username, Primary key of updated record. Can SQL Server track this info?


p

 

[tlbroadbent]

You have to write your own audit functions or purchase a thrid party product. SQL doesn't provide the kind of auditing you described. In fact, it realy does poorly when it comes to creating audit trails.

FYI: When writing your own functions, you would use triggers. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.