Showing posts with label last update. Show all posts
Showing posts with label last update. Show all posts

Thursday, August 4, 2011

How to Check When Your DB was Last Updated - Sql Server

SELECT OBJECT_NAME(OBJECT_IDAS TableNamelast_user_update,* FROM sys.dm_db_index_usage_statsWHERE database_id DB_ID'Database')