DECLARE @search VARCHAR(50)
SET @search = 'reemplazo_bien'
SELECT SPECIFIC_CATALOG ,
ROUTINE_NAME ,
ROUTINE_DEFINITION ,
ROUTINE_TYPE ,
CREATED ,
LAST_ALTERED
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%' + @search + '%'
--AND ROUTINE_TYPE ='PROCEDURE'
ORDER BY ROUTINE_NAME
