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