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 - 2004-03-30 : 08:42:37
|
| Ann writes "I have a client that has asked for a real time display on their website, for "anytime anything has been updated". Their database (MSSQL2000) has a good number of tables.I could do something like a union of all important tables and get the value of a column most tables have, i.e. (datelastmodified) but was hoping there might be some kind of system object that may carry this information -Is there such a beast?" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-30 : 12:32:30
|
| Have you looked at 3rd party auditing tools?Tara |
 |
|
|
|
|
|
finding last update/insert actions on user tables, by DB