Thank you so much for your help.

There are a lot of SPs that I would expect to see (I know they are run frequently) but they don't appear to be...

Thank you! Worked like a charm.

Yes, I did comment out the where clause.

Is there any way to get the actual name of the stored procedure (as opposed...

Yes, I do realize that only those SPs that are cached will be returned (and the cache is flushed each time the server is re-started). I know the information...

I am able run it on the Master database and your explanation makes sense.

I am sure that the database I want to run it in has some 2000 compatibility issues.

Is...