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.
For example:
CREATE PROCEDURE dbo.getdata
AS
BEGIN
EXECUTE dbo.up_updatetable ;
END;