• Good work, Mike. Handy image, Troy.

    One thing to keep in mind when using INFORMATION_SCHEMA.ROUTINES to search through stored proc text is that it's limited to the first 4000 characters.

    If you have procedures that are larger, query sys.sql_modules or the underlying sysobjects and syscomments tables.