Synchronize a stored procedure between two servers

CREATE PROCEDURE [dbo].[spSynchStoredProcedure]
	@ProcedureName VARCHAR(50) = NULL,
	@SourceServer VARCHAR(50) = NULL,
	@SourceDatabase VARCHAR(50) = NULL,
	@TargetServer VARCHAR(50) = NULL,
	@TargetDatabase VARCHAR(50) = NULL
AS
BEGIN
	SET NOCOUNT ON;
	DECLARE @STRSQL NVARCHAR(MAX);
	DECLARE @Params NVARCHAR(MAX);
	DECLARE @IsExisted BIT;
	DECLARE @ProcedureSource NVARCHAR(MAX);
	DECLARE @Tmp NVARCHAR(MAX);
	SET @IsExisted = 0;
	SET @STRSQL = N' SELECT @IsExisted = 1
					FROM ' + @TargetServer + '.' + @TargetDatabase + '.sys.objects
					WHERE name = ''' + @ProcedureName + ''' AND Type = ''P''';
	SET @Params = N'@IsExisted BIT OUTPUT';
	EXEC sp_executesql @STRSQL, @Params, @IsExisted = @IsExisted OUTPUT
	IF (@IsExisted = 1)
	BEGIN
		SET @STRSQL = N'EXEC ' + @TargetServer + '.' + @TargetDatabase + '.dbo.sp_executesql N''DROP PROCEDURE ' + @ProcedureName + '''';
		--PRINT @STRSQL;
		EXECUTE(@STRSQL);
	END;
	
	--Insert to temp table since some stored procedures contains over 4000 characters
	CREATE TABLE #tblTmp(item NVARCHAR(MAX));
	SET @STRSQL = N'INSERT INTO #tblTmp
					SELECT t1.text 
					FROM ' + @SourceServer + '.' + @SourceDatabase + '.dbo.syscomments t1
					INNER JOIN ' + @SourceServer + '.' + @SourceDatabase + '.dbo.sysobjects t2 on t1.id = t2.id
					WHERE t2.xtype = ''P''
					AND t2.name = ''' + @ProcedureName + '''';
	EXECUTE(@STRSQL);
	
	SET @ProcedureSource = '';
	DECLARE MyCursor CURSOR FOR
		SELECT item FROM #tblTmp
	OPEN MyCursor
	FETCH FROM MyCursor
	INTO @Tmp
	WHILE @@FETCH_STATUS = 0
	BEGIN
		SET @ProcedureSource = @ProcedureSource + @Tmp;
		FETCH NEXT FROM MyCursor
		INTO @Tmp
	END
	CLOSE MyCursor
	DEALLOCATE MyCursor

	DROP TABLE #tblTmp;
	--PRINT @ProcedureSource;

	SET @ProcedureSource = REPLACE(@ProcedureSource, '''', '''''');
	SET @STRSQL = N'EXEC ' + @TargetServer + '.' + @TargetDatabase + '.dbo.sp_executesql N''' + @ProcedureSource + '''';
	--PRINT @ProcedureSource;
	--PRINT @STRSQL;
	EXECUTE(@STRSQL);
END