Tuesday, October 26, 2010

GETTING THE LASt UPDATION DATE OF A TABLE

GETTING THE LASt UPDATION DATE OF A TABLE


select OBJECT_NAME(object_id) as databasename ,
last_user_update , *
from sys.dm_db_index_usage_stats
where database_id = DB_ID('sec45')
and OBJECT_ID = OBJECT_ID('schule_busmaster')




http://blog.sqlauthority.com/2009/05/09/sql-server-find-last-date-time-updated-for-any-table/

No comments:

Post a Comment