Synchronize a view between two servers

CREATE PROCEDURE [dbo].[spSynchView]
@ViewName 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 @ViewSource NVARCHAR(MAX);
SET @IsExisted = 0;
SET @STRSQL = N' SELECT @IsExisted = 1
FROM ' + @TargetServer + '.' + @TargetDatabase + '.sys.objects
WHERE name = ''' + @ViewName + ''' AND Type = ''V''';
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 VIEW ' + @ViewName + '''';
EXECUTE(@STRSQL);
END;

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

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