Synchronize a function between two servers

CREATE PROCEDURE [dbo].[spSynchFunction]
@FunctionName 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 @Source NVARCHAR(MAX);
SET @IsExisted = 0;
SET @STRSQL = N' SELECT @IsExisted = 1
FROM ' + @TargetServer + '.' + @TargetDatabase + '.sys.objects
WHERE name = ''' + @FunctionName + ''' AND Type IN (''FN'', ''TF'',''IF'')';
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 FUNCTION ' + @FunctionName + '''';
EXECUTE(@STRSQL);
END;

SET @STRSQL = N'SELECT @Source = t1.text 
FROM ' + @SourceServer + '.' + @SourceDatabase + '.dbo.syscomments t1
INNER JOIN ' + @SourceServer + '.' + @SourceDatabase + '.dbo.sysobjects t2 on t1.id = t2.id
WHERE t2.xtype IN (''FN'', ''TF'',''IF'')
AND t2.name = ''' + @FunctionName + '''';
SET @Params = N'@Source NVARCHAR(MAX) OUTPUT'
EXEC sp_executesql @STRSQL, @Params, @Source = @Source OUTPUT

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