DECLARE
@SSQL1 NVARCHAR(4000),
@SSQL2 NVARCHAR(4000)
BEGIN
SET @SSQL2 = 'ALTER PROCEDURE [DBO].[SP_FILE_PETI_CONSULTAR] (@PETI VARCHAR(8))
              AS
              SELECT TOP 1 FILE_CONTENT FROM SRVFILE.DOCUMENTOSFINDIRECT.DBO.FILE_PETICION_TEST
              WHERE PT_CD_PETICION = @PETI ORDER BY AUD_FH_MODIFICACION'
SET @SSQL1 = 'USE [CIL_DB]
              GO
              SET ANSI_NULLS ON
              GO
              SET QUOTED_IDENTIFIER ON
              GO
              EXEC (''' + REPLACE(@SSQL2, '''', '''''') + ''')'
EXEC SP_EXECUTESQL @SSQL1
END