Find text in sql db or search sp, table, column name in sql

select * from sysobjects where id in(select id from syscomments where text like '%tablename%') and xtype = 'p'