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 - 2001-11-09 : 14:35:18
|
| Gerald writes "We work with a number of databases that are updated on a non-scheduled/regular basis.I'd like to be able to determine when the table was last updated/modified (ie records added/changed/deleted, or the table was last restored/recreated, etc). This would allow me to inform users of how up-to-date the information is.The tables creation date is of no use to me, and it is not currently possible to modify the tables and stored procedures to include a "lastupdated" field.Is there any way to get this information or am I out of luck??" |
|
|
|
|
|
How do I determine when a table was last updated (ie records added/changes/deleted/etc)??