Tables being used

• SQL_Surfer

  SSCrazy Eights

  Points: 8320

  More actions

  March 12, 2015 at 2:17 pm

  #150329

  How can I tell which tables are being used in a particular db? Is there a script for that?

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  March 12, 2015 at 4:13 pm

  #1783741

  What do you mean by being used?

  In that precise moment? In the last days? That have data? That are included in stored procedures, functions or views?

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• ss-457805

  SSCertifiable

  Points: 5872

  More actions

  March 12, 2015 at 4:21 pm

  #1783742

  Hi, You can use "sys.dm_db_index_usage_stats" to get when the tables were last accessed.

  blog: http://sarveshsingh.comTwitter: @sarveshsing

• ss-457805

  SSCertifiable

  Points: 5872

  More actions

  March 12, 2015 at 4:24 pm

  #1783744

  You can use "sys.dm_db_index_usage_stats" to find out when the tables were last accessed.

  Sarvesh

  blog: http://sarveshsingh.comTwitter: @sarveshsing