Execute the following script in query editor to create a keyword search procedure for stored procedures, functions and views:

USE AdventureWorks

CREATE PROCEDURE procSearchProgrammingObjects (@KeyWord char(50))
AS
BEGIN
DECLARE @SQLCommand NVARCHAR(MAX)

SELECT @SQLCommand = 'SELECT ObjectName=o.Name,'
+ ' o.Type, CreateDate=o.crdate '

+ CHAR(13) + 'FROM sys.syscomments c'

+ CHAR(13)+'JOIN sys.sysobjects o'
+ CHAR(13) + 'ON c.ID = o.ID'
+ CHAR(13) + 'WHERE c.text LIKE ''%'+rtrim(@KeyWord)+'%'''
+ CHAR(13) + 'ORDER BY Type, ObjectName'

PRINT @SQLCommand
DECLARE @Result TABLE(ObjectName varchar(50), [Type] char(10), CreateDate datetime)

INSERT @Result
EXEC(@SQLCommand)
SELECT * FROM @Result ORDER BY [Type]
RETURN
END

-- EXEC procSearchProgrammingObjects 'Vendor'

-- EXEC procSearchProgrammingObjects 'Person.Contact'