Awesome, Theo, and thank you for sharing. I wish I knew how to tweak the code to add some of the other functionality you showed in your post. 🙂

On a...

Hi SSChasing.

I've been trying to accomplish the same thing using a variety of methods, but haven't been successful yet. Were you ever able to find a way to record the...

join sysobjects o on b.objectid=o.id

that way you can filter on xtype = 'P' and you aren't restricted to procs named sp%.