How to Search a Stored Procedure or a View in a Database

Search views, and stored procedures in a database with a specific name

To get all store procedures or views list iin a database.

User <DatabaseName>

declare @search varchar(max)

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+'%'
ORDER BY 2,1;

Output