Thursday, August 4, 2011

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

SELECT OBJECT_NAME(OBJECT_ID) AS TableName, last_user_update,* FROM sys.dm_db_index_usage_statsWHERE database_id = DB_ID( 'Database')
Posted by Zeeshan Ahmed Khan at 8/04/2011 08:30:00 AM
Labels: , , ,

1 comment:

  1. AJ BandaAugust 5, 2011 at 6:16 AM

    I actually created a post that summarizes all the 'must-know' commands on sql.. visit my blog :)

    ReplyDelete

Subscribe to: Post Comments (Atom)