Busqueda de cadena en todos los elementos de SQL SERVER

SELECT
  Object_name(so .parent_object_id) Parent_Name,
  so .name [Objeto],
  so .type_desc [Tipo],
  so .create_date [Creado],
  sm.definition [Texto]
FROM sys .objects so
INNER JOIN sys. sql_modules sm ON so.object_id = sm.object_id
WHERE  CONVERT(VARCHAR(8000),sm.definition) LIKE '%[PATRONBUSQUEDA]%'