• sometimes when i'm searching for a particular procedure....i use the following:

    use [your DB here]

    GO

    SELECT Distinct SO.Name

    FROM sysobjects SO (NOLOCK)

    INNER JOIN syscomments SC (NOLOCK) on SO.Id = SC.ID

    AND SO.Type = 'P'

    AND SC.Text LIKE '%YOUR SEARCH TEXT HERE e.g. TABLENAME%'

    ORDER BY SO.Name