Table usage

• sunny.tjk

  SSCertifiable

  Points: 5041

  More actions

  July 11, 2011 at 9:40 am

  #241329

  Hi everyone,

  Does anyone has a script to find out who have been using the tables in a database since a specific date?

  For example: I need to find out who all used the tables in an ABC database since Feb 1st 2011.

  Thanks.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  July 11, 2011 at 9:49 am

  #1351178

  That works great, but only since last server restart.

  http://sqlblog.com/blogs/aaron_bertrand/archive/2008/05/06/when-was-my-database-table-last-accessed.aspx