How to find out when was the last time a database table was accessed by a user
Posted on 2011-03-25
I'm trying to find out when was the last time that a specific database and its tables was accessed by a user. Details as following:
There are about 30 databases on SQL 2000 server, and I'd like to get rid off some before upgrading to SQL 2005. I want find out which database(s) has not been used for more than 12-month. In addition, is it possible that I can narrow it down to table/stored procedure level, i.e. which table or stored procedure has not been used for past 12-month.