Busqueda en SP (Stored Procedure)

Recopilación de dudas técnicas, db scripts y consultas de administración y desarrollo sobre bases de datos Microsoft SQL Server.

				SELECT ROUTINE_NAME, ROUTINE_DEFINITION, *
				FROM INFORMATION_SCHEMA.ROUTINES
				WHERE ROUTINE_DEFINITION LIKE '%TEXTO A BUSCAR %'
				AND ROUTINE_TYPE='PROCEDURE'

				-----------------------------------------------

				SELECT Name
				FROM sys.procedures
				WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%SE RETRASO LA UNIDAD%'

				-----------------------------------------------

				select distinct 'SP_HELPTEXT ' + name 
				from sysobjects o JOIN syscomments c ON o.id  =c.id  
				where  text like '%SE RETRASO LA UNIDAD%'