The following code will help you search a text that is part of table/view, index, Key or Stored Proc, functions etc... you can give partial names for search too, it works
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SearchSqlObjectsForText]
(
@SearchText NVARCHAR(100)
)
AS
SELECT DISTINCT
CASE xtype
WHEN 'U' THEN 'User Table'
WHEN 'P' THEN 'Stored Procedure'
WHEN 'V' THEN 'View'
ELSE xtype
END AS ObjectType
, o.name
from
sysobjects o
left outer join
syscomments c
on c.id = o.id
where c.text LIKE '%' + @SearchText + '%'
OR o.name LIKE '%' + @SearchText + '%'
GO