I want to take all stored procedures and create them under a new name. My problem is with procedures that are called from other procedures .
To rename a procedure is no problem for me. But to change/duplicate the procedures that still reference them by their old names is a problem.
CREATE PROCEDURE dbo.getdata AS BEGIN EXECUTE dbo.up_updatetable ; END;