Search any SP/Table/View/Function in SQL Server

SELECT DISTINCT so.name [Name], so.xtype [Type]
FROM sysobjects so INNER JOIN syscomments sc 
     on so.id = sc.id
WHERE sc.text like '%<SearchText>%'