How can I determine when a sproc or table was last used?
I suspect that I have many obsolete tables and sprocs in my database but how can I find out for sure??
Thanks,
DL

The only way I have seen this done is to edit the stored proc with some code in the very beginning to write to a log file every time the stored proc was run, and perhaps track the user id. I don't believe SQL has any built in functionality to do this.

There are some third party tools designed to do that type of thing on Oracle servers, I am not sure if they have been ported to MS SQL. Another thing for you to possibly use is sql trace, running to some sort of a log file.