Get stored procedures list that contains specific text

Some times we may need to find the stored procedure that contains specific text, word or tablename. by using the below sql query we can do that very easily.

The below query will return the list of stored procedure that are having specific text "internal".

SELECT Name FROM sys.procedures WHERE OBJECT_DEFINITION(object_id) LIKE '%internal%'