How to check the integrity of stored procedures

Question

We have a large database containing many stored procedures. Now we are updating our database, but some stored procedures still use the old structure. We found that most of them use sp_depends, but some sp are slipping.

I was wondering if there was a way to check all stored procedures. If they call a column that no longer exists, you will receive an error message.

thanks

Answer 1

, 100% , , . , RedGate SQL Dependency Tracker.

http://www.red-gate.com/products/SQL_Dependency_tracker/index.htm

.

Answer 2

, , , " ".