Unanswered: Verifying the Validity of Stored Procs
I have about 1,000 stored procs that need to be migrated to a new database. The problem im finding is that some of them are no longer valid (they may reference a table or column that no longer exists).
Is there an easy way I can audit all the procs verifying which are still valid and which need to be fixed or removed.
If I attempt to import (or copy a database to a new server) this seems to cause me a problem. I get an import error at 99% with the error msg displaying just the column name that has a problem.
I then have to go through all the procs and find the delinquent one and fix or remove it.