Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rhankin
Starting Member
5 Posts |
 Posted - 2005-05-25 : 08:44:46
|
| I have SQL profiler tracing each time a stored procedure starts. This will give me an idea of which Stored Procedures are being used and which ones aren't.I want to do the same things for tables. We have many applications which create tables and procedures and do not drop them when they are finished. I would like to capture any reads or writes to the tables so i can in effect create a "last access time" report to show redundant objects. Does anyone have any ideas on how i can do this besides simply checking row counts?I need the same thing for view too |
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2005-05-27 : 08:12:31
|
| Save your profiler filtering the tables/views accessed to a table, then get your desired infos from there.Donn Policarpio |
 |
|
|
|
|
|
Use Profiler to check table usage