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: