Reporting on Table Use

[mingus]

Is is possible to get a report from SQL Server about either:

- how many times a table has been used
- when the last time a table was used (queried, changed)

I have a big database and I think some of the tables are bunk. But I am not 100% sure, so if I could verify they haven't been used for last 30 days it would easy my soul.

Tried to find this info, but don't see anything!

 

[tlbroadbent]

In case you are still searching for an answer, SQL Server does not track last time accessed or number of times accessed for objects or databases. You can use SQL Trace to trace all activity on a databse and extract the tables, views and stored procedures accessed. I'm sure there are 3rd party tools you could use to provide this type of auditing. Try searching the WEB for SQL Server audit or similar strings. Good luck! Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.