How to find a text inside SQL Server code

Create the procedure (SQL Server 2012):

[code SQL]CREATE PROCEDURE sp_FindText @p_text varchar(100)
AS
SELECT DISTINCT name, type
FROM sys.sysobjects so WITH (NOLOCK)
INNER JOIN sys.syscomments sc WITH (NOLOCK)
ON so.id = sc.id
WHERE text LIKE '%' + @p_text + '%'
ORDER BY name[/code]

Now, you can use sp_FindText to finding text inside procedures, functions, triggers, views etc:

[code SQL]sp_FindText 'my_text';[/code]

Use this procedure, you can watch here:
[link http://www.learn-with-video-tutorials.com/how-to-find-a-text-inside-sql-server-code]http://www.learn-with-video-tutorials.com/how-to-find-a-text-inside-sql-server-code[/link]
or here:
[link http://www.youtube.com/watch?v=EXFgC8SBbdI]http://www.youtube.com/watch?v=EXFgC8SBbdI[/link]