Buscar texto en sps SQL server

Buscar un texto en todos los sps de una base de datos:

declare @search varchar(50)

SET @search = 'CatalogoInformacion'

SELECT

ROUTINE_NAME

,ROUTINE_DEFINITION

FROM

INFORMATION_SCHEMA.ROUTINES

WHERE

ROUTINE_DEFINITION LIKE '%' + @search + '%'

--AND ROUTINE_TYPE ='PROCEDURE'

ORDER BY

ROUTINE_NAME