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 |
|
gdeconto
Posting Yak Master
107 Posts |
 Posted - 2001-11-06 : 20:01:46
|
| I have a series of tables that are updated by users and scheduled tasks intermittently.The contents of these tables are displayed on a web-based report.I would like to be able to show users when the table was last updated (ie rows added or deleted, fields changed, etc) for reporting purposes.Unfortunately, I am unable to change the table structures and/or stored procedures for many of them (internal reasons).Is there any way for me to be able to tell when a table was last updated without adding new fields or changing the stored procedures?? ie thru some sort of internal parameter or stored procedures?any advice appreciated. thx |
|
|
|
|
|
determining when a table was last modified