SQL Server Performance

When a Table was last accessed

Discussion in 'SQL Server 2005 General DBA Questions' started by L0st_Pr0phet, Oct 26, 2007.

  1. L0st_Pr0phet Member

    Can anyone tell me if there is a way to find out when a table was last accessed or updated.
    I dont think there is but thought I would give it a shot!I
  2. L0st_Pr0phet Member

    I know you can possibly make use of the rowmodctr in sysindexes but that only hold IUD modifications and only since last stats were updated we were looking for something inclusive of selects and over a longer period.
  3. Adriaan New Member

    If you allow access to data only through stored procedures, then you can log anything you want.
    Otherwise, you can only log through triggers, which means reading data goes unnoticed.
    You might figure out how to distill the information from a trace, but that will be pretty ludicrous - and why do it after the fact if you can do it up front - as in my first suggestion.
  4. satya Moderator

    Is it in SQL 2005?

Share This Page