You could also use this free utility application to search SQL code while optionally ignoring comments, and/or to script out selected SQL routines in correct dependency order...
Creator of SQLFacts, a free suite of tools for SQL Server database professionals.