Asp.NET Tips

Following SQL will return stored procedures that using supplied string: CREATE PROCEDURE [dbo].[proc_FindTextInsideSP] ( @s varchar(50) ) AS SET NOCOUNT ON; SELECT ROUTINE_NAME, CREATED, LAST_ALTERED FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%' + @s + '%' ORDER BY ROUTINE_NAME; RETURN;