Sql find stored procedure by name

Let's use this line of sql query code to find stored procedure inside database:

select * from sys.procedures where name like '%name_of_proc%'

the magic line was very useful for me today.

SHARE SHARE SHARE