T-SQL PROCÉDURE DE RECHERCHE DE PROCÉDURES À PARTIR D'UN TEXTE

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE  PROCEDURE [dbo].Tools_SearchSP  @SEARCH char(128)
As
select distinct sysobjects.xtype, sysobjects.name 
from syscomments
inner join sysobjects on sysobjects.id = syscomments.id
where syscomments.text like '%' + ltrim(rtrim(@SEARCH)) + '%'
order by 1
return
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO