select

object_name(m.object_id),schema_name(schema_id)

from

sys.sql_modules m join sys.all_objects a

on

m.object_id=a.object_id

where

definition like '%searchexpr%'