Find Redundant Database Objects

[u104741]

Is there an easy way to find out when a stored proc or a view was last run in sql server 2000.

I am trying to clean up a database but dont want to remove views, procedures and functions that other applications or dts packages may be calling upon for data.

Ideally i was kinda hoping that there is a system table that keeps a record of the last time each object is called???

Any ideas would be grately appreciated...

j

 

[SQLDenis]

Nope, run profiler for a couple of days and start renaming objects first then remove after nothing breaks

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[ptheriault]

Do you have access to the application code? It might be eassier to search through the code to get a list of objects that are currently accessed. It might not be the best aproach but it will provide you with a starting list of good objects.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[u104741]

thanks guys i was afraid that was the answer. Unfortunatly i dont have access to the code there are 20 or so apps + 100s of DTS packages running on dozens of different servers.. + views and SPs from other DBs on other servers that could be calling into the DB im working on... its a proper mess me thinks!! i think monitoring will be the only way....