• Either of the other suggestions will work, but I would agree with Steve because INFORMATION_SCHEMA is an ANSI standard while sys.procedures is a Microsoft view that could be deprecated or changed.