I am using SQL Server 2005 and I have about 250 stored procedures which have been made over the years. Only about 150 of these are actually being used. The problem is, there are so many that I can't possible go through the whole application and find which stored procs are really being used... Is it possible to query sql server and find all stored procedures that have been used in the last 6 months? I would like to delete the rest...
Thanks,
Br
Our community of experts have been thoroughly vetted for their expertise and industry experience.