Search a Text in a Database

This Query will help you in searching a text in a Database.

SELECT Distinct sysobjects.Name
FROM sysobjects
JOIN syscomments on sysobjects.Id = syscomments.ID
AND sysobjects.Type = 'P'
AND Text LIKE '% Alwyn%'
ORDER BY sysobjects.Name