Synchronize several stored procedure between two servers

CREATE PROCEDURE dbo.spSynchMultiProcedures
@ProcedureNames NVARCHAR(MAX) = NULL --Separate each procedures by comma
, @SourceServer VARCHAR(50) = NULL
, @SourceDatabase VARCHAR(50) = NULL
, @TargetServer VARCHAR(50) = NULL
, @TargetDatabase VARCHAR(50) = NULL
AS
BEGIN
SET NOCOUNT ON;
DECLARE @POS BIGINT;
DECLARE @POS1 BIGINT;
DECLARE @ProcedureName VARCHAR(50);
SET @POS = 0;
SET @POS1 = CHARINDEX(',', @ProcedureNames, @POS);
WHILE (@POS1 > 0)
BEGIN
SET @ProcedureName = SUBSTRING(@ProcedureNames, @POS, @POS1 - @POS);
PRINT @ProcedureName;
EXEC dbo.spSynchStoredProcedure @ProcedureName 
, @SourceServer
, @SourceDatabase
, @TargetServer
, @TargetDatabase

SET @POS = @POS1;
SET @POS1 = CHARINDEX(',', @ProcedureNames, @POS + 1);
END
IF @POS < LEN(@ProcedureNames)
BEGIN
SET @ProcedureName = SUBSTRING(@ProcedureNames, @POS + 1, LEN(@ProcedureNames) - @POS);
PRINT @ProcedureName;
EXEC dbo.spSynchStoredProcedure @ProcedureName
, @SourceServer
, @SourceDatabase
, @TargetServer
, @TargetDatabase
END
END;