Kalyan Kumar Akula's Blog : This Blog is about SQL Server
Thursday, July 26, 2012
To know the last update time of a table on a database
--- To know the last update time of a table on a database ---
SELECT OBJECT_NAME(OBJECT_ID) AS Db_Name, last_user_update
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'KALYANDB')
AND OBJECT_ID=OBJECT_ID('AllLog2')
No comments: