ALTER proc [dbo].[SearchObjects] 
	@database varchar(100),
	@searchString varchar(100)
As
	Declare @Sql nvarchar(1000)

	Set @Sql = 'SELECT Distinct SO.Name	FROM ' + @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