How to search for text in a SQL Server stored procedure, function, or view?

You can use the following T-SQL query to search for text in a SQL Server stored procedure, function, or view.

Code:

SELECT	DISTINCT o.name AS Object_Name, o.type_desc
FROM		sys.sql_modules m
INNER   JOIN	sys.objects o ON m.object_id = o.object_id
WHERE		m.definition Like '%search term%'

Fig 1. Search text in stored procedure, function and view using t-sql