I added a quick option to George's original block to specify the DB you want to search. This way it can sit in Master and be called from anywhere on the server.

But this split at character 4000 in syscomments is an eye opener. Means this solution isn't complete, even for searching procs only.

Ken

ALTER proc [dbo].[SearchObjects]

@database varchar(100),

@searchString varchar(100)

As

Declare @Sql nvarchar(1000)

Set @Sql = 'SELECT Distinct SO.NameFROM ' + @database + '.dbo.' + 'sysobjects SO (NOLOCK) ' +

'INNER JOIN ' + @database + '.dbo.' + 'syscomments SC (NOLOCK) on SO.Id = SC.ID ' +

'AND SO.Type = ''P'' AND SC.Text LIKE ''%' + @searchString + '%'' ORDER BY SO.Name'

Exec sp_executesql @Sql