SQL Object Access Tracking

SQL Object Access Tracking

 

  

I have taken over a rather large project that has had multiple developers
working on it over the years. What I am trying to determine is if there is
way to track which tables, stored procs, and views are being accessed.
Basically I am trying to get a feel for what is still in use and what is not
without poring over profiler trace files for the next 6 months. ;) I
understand that some stuff is not used frequently and will probably be
trying to write something I can run over the course of a month. I have vb
and tsql experience so coding solution/suggestions are great too.

Anyone have any ideas?

Thanks,
Dan

MS Sql Server LazyDBA home page