DZone Snippets: SQLServer code http://snippets.dzone.com/posts Mon, 06 Oct 2008 09:28:26 GMT DZone Snippets: SQLServer code Search for specific text in all stored procedures http://snippets.dzone.com/posts/show/3905 <code> <br />declare @search varchar(50) <br />SET @search = 'searchterm' <br /> <br />SELECT <br /> ROUTINE_NAME, <br /> ROUTINE_DEFINITION <br />FROM <br /> INFORMATION_SCHEMA.ROUTINES <br />WHERE <br /> ROUTINE_DEFINITION LIKE @search <br />ORDER BY <br /> ROUTINE_NAME <br /></code> Thu, 26 Apr 2007 03:08:05 GMT http://snippets.dzone.com/posts/show/3905 mrtrombone (Mark Easton)