Click here to Skip to main content
15,861,340 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I need to find out the list of stored procedures which are not in use for SQL server 2005.
I found there is something called "sys.dm_exec_procedure_stats " for SQL server 2008.

Can you please suggest your ides here to do the same job for SQL server 2005.


Many Thanks.
Posted

1 solution

AFAIK, the only stats you can gather in 2005 are using sys.dm_exec_query_stats (which are only since the last SQL restart. It's more complex to use than sys.dm_exec_procedure_stats which is probably why it was introduced in 2008...:laugh:

This might help: http://sqlserverperformance.wordpress.com/2006/11/16/sql-server-2005-stored-procedure-execution-statistics/[^]
But I haven't tried it - I don;t have 2005 and haven't had it for a long time!
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900