Loging data changes in SQL Server 2008

GrynderGrynder Member Posts: 106
If multiple users access and modify data what is the best way to log the changes and the user who made the changes? Or at least the last user that modified a record.

Does SQL 2008 have anything like this? or should I add 2 columns to the table that are updated with time and user every time there is a modification?

Comments

Sign In or Register to comment.