>We have two/three hundred stored procedures.
>Periodically by making tables changes we break the stored procedures and we do not know it.
>Is there a way to “check syntax” and “recompile” all stored procedures at once?
>Just to make sure tables changes did not effect stored procedures!

Syntax Check Stored Procedures Thread #948342