Tracking who is changing what

[aimlion11yahoo]

We are building an inventory management system complete with BOM. It is important to track what employee is updating what tables. Currently all such tables have a Date field that is updated when a change is made, and an EmployeeID field which records the employee making the change. I am wondering if someone knows of a better way to track this information. Any suggestions?

Dana

 

[manmaria]

I would think of DML triggers for any DML changes and DDL triggers for the table changes.

And also at the databse level, in management studio you can look at the "Reports" tab to see if any of the reports might help your requirement.

HTH

 

[mrdenny]

The first question to ask will be what version of SQL Server are you using?

If all you have is two columns one for the last user and one for the last date then you only know who made the most recent change. If you want to to track more than that, you'll need another table to track this information in.

If you are using stored procedures to do your data changes then you can put this auditing code. If not you can use triggers to do this.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com