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!