Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-04 : 08:18:07
|
| Joachim writes "Hello,we are running an application with very sensitive data. We would like to track/report on :- which user changed data at which time in which table/column.The application does not automatically maintain this data. It is not part of the application data model either.--> Is there a possibility to obtain this data from sqlserver transaction log / traces / sys-tables or... ?Thanx,Joachim Blankenstein" |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-12-04 : 08:23:26
|
| Please have a look at ENTEGRA from www.lumigent.comHTHFranco |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-12-04 : 13:11:02
|
| There is a homegrown method to do this as well.You create a Update tracking table and use an update trigger to poulate it.JimUsers <> Logic |
|
|
|
|
|
|
Logging modification times and users