We have a large database containing a lot of stored procedures.
Now we are updating our database but some stored procedures still use the old structure.
We've found most of them using 'sp\_depends' but some sp's slipped through.

I was wondering if there isn't a way to check all stored procedures. If they call for a column that doesn't exist anymore you get an error.

Thx