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 |
|
bbasir
Yak Posting Veteran
76 Posts |
 Posted - 2008-04-08 : 20:00:43
|
| I wanted to know that if there is a way to know that when the last time a table was used i.e. selct, update insert or delete? or accessed?I have quite a few redundant database objects i.e. tables and sps in one of my database and I need to know programmatically that which one's are obsolete?I donot want to di g into the applications and seearch each one of them and see which are being actually used and was wondering if there is some utility in sql that can help me.I have heard that I can use information schema but donot know if that is true? or how uit can be used? |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-08 : 22:22:49
|
information_schema will not tell you which tables have been accessed recently. try this: rename the tables you think are obsolete and see if anyone screams.  otherwise you could turn on profiler for a day and look through the trace.
elsasoft.org |
 |
|
|
|
|
|
Information Schema Question(is table being used? )