How can I tell when a SQL database was last updated?

Question

If a user wants to find out when was the last table updated he can query dynamic management view (DMV) – sys.dm_db_index_usage_stats and easily figure out when was the table updated last. 9 мая 2009 г.

When was SQL last updated?

Product VersionsLatest Service PackCU Release DateSQL Server 2016SP2 (KB 4052908)3/29/2021SQL Server 2016SP1 (KB 3182545)7/9/2019SQL Server 2016N/A11/22/2017SQL Server 2014SP3 (KB 4022619)1/12/2021

How do I find the last update in SQL Server?

Right-click on the statistics and go to properties. It opens the statistics properties and shows the statistics columns and last update date for the particular statistics.

How do I check for recent changes in database?

Query the sys. objects table to find the objects that changed and filter by modify_date and type ; U = User table, P = Stored procedure. This approach will tell you what objects have changed, but not the specific changes.

How can I tell when a SQL Server database was last used?

To get the last time when table was accessed in SQL Server, you can use SQL Server dynamic management view sys. dm_db_index_usage_stats, which returns counts of different types of index operations and the time each type of operation was last performed.

Expert · Answer