SELECT NAME
	,type_desc
FROM sys.all_sql_modules s
INNER JOIN sys.all_objects o ON s.object_id = o.object_id
WHERE DEFINITION LIKE '%keyword%'
ORDER BY type_desc
	,NAME