Objects Dependent on Replaced Procedures

If a replaced procedure is called by another procedure, both procedures are recompiled when called. If the interface of the replaced procedure does not match that in the calling procedure, then the calling procedure must be replaced, otherwise, the calling procedure raises an error. You can execute sp_depends on the replaced procedure to check for any calling objects.