search-schema.sql

select distinct name
  from sysobjects o
 inner join syscomments c on o.id = c.id
 where text like '%search%'