/*
CREATE proc dbo.p_FindText
@strFind varchar (100),
@varDBName varchar (100) = 'Northwind'
AS
BEGIN
SET NOCOUNT ON
DECLARE @SQLString nvarchar (1000)
SELECT @SQLString = N'SELECT distinct ' +
'name SP_Name, ''sp_helptext '''''' + name + ''''''''SP_HT ' +
'FROM [' + @varDBName + '].[dbo].[sysobjects] inner join [' + @varDBName + '].[dbo].[syscomments] ' +
'on [' + @varDBName + '].[dbo].[sysobjects].id = [' + @varDBName + '].[dbo].[syscomments].id ' +
'where xtype = ''P'' ' +
'and text like ''%' + @strFind + '%'' ' +
'order by name '
exec sp_executesql @SQLString
END
*/