How can I identify unused or seldomly used stored procs in sql server 2000?
I'm currently in the preparatory stages of migrating my SQL Sever 2000 to SQL Server 2014.I would like to identify all stored procs that have never been called or used and purge them before migration. Does anyone have an idea as to how to accomplish this task? Can someone point me in the right direction.
If they aren't preventing the upgrade, I would leave them alone for now. I would get the upgrade done and use the greatly improved DMVs in SQL 2014 to identify unused procs after the upgrade has bedded in.