CREATE PROC [dbo].[system_searchInStoredProcs]
(
    @str nvarchar(100)
)
AS
BEGIN
	 SELECT name sp, Object_definition(object_id) text
	FROM   sys.procedures
	WHERE  Object_definition(object_id) LIKE '%'+@str+'%'


END