Last accessed tables and stored procedures.

• Amarnath Solai

  Grasshopper

  Points: 19

  More actions

  March 20, 2004 at 1:46 am

  #86299

  Is there a way to find out (from the system tables) the last accessed table and the last accessed stored procedure ?

  Is SQL server stores date and time of access for each table, procedures ?

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  March 22, 2004 at 5:51 am

  #499735

  No. You will have to create your own audit method. With sp to access tables, triggers or profiler.