locked
Who has accessed my Sql server databases objects and when? RRS feed

  • Question

  • Hi Experts,

    I have multiple databases and tables at a server. Now, I want to drop those tables which are not used from very long time. In this regards, I need to find out the table name, user name and last accessed/used date. I found multiple thread on net for the same but not exactly which I want. By using Sys.dm_db_index_usage_stats, we can found the object name and last accessed but not the user/login name. Also, this data will be reset once server get restarted. But my requirement is something else like (table name, user name and last accessed/used date). Please let me know if any solution...

    Thanks,

    Sanjay

    Thursday, December 4, 2014 10:55 AM

Answers

All replies