We have a Microsoft SQL Server database. We're not manually keeping track of when edits or updates to the data in the tables were made. Is there still a way to find out which tables have had their data updated within, say, the last 24 hours?
We have a Microsoft SQL Server database. We're not manually keeping track of when edits or updates to the data in the tables were made. Is there still a way to find out which tables have had their data updated within, say, the last 24 hours?
1条答案
按热度按时间eit6fx6z1#
SQL Server does not track this information by default, though there is a way to see if any updates have been attempted since a given point in time using the dynamic management view
sys.dm_db_index_usage_stats
.Some caveats: