Find Last Date Time Updated for Any Table 

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'AdventureWorks')
AND OBJECT_ID=OBJECT_ID('test')
posted @ 2009-05-09 16:53  new 维生素C.net()  阅读(150)  评论(0)  编辑  收藏  举报