The same cons as with most all of the other existing tools I've found, they don't give me that "treeview" of calls allowing me to drilldown from a high level...

I'm trying to nail down precisely how their dependency level is determined at the moment.  That's a vague representation of what I'm looking for, it's just whether or not it's producing what...

Thanks for the link.  I just viewed it's sample output at http://www.apexsql.com/zips/apexsqldoc_example.chm

While it seems capable of listing all of the objects, I don't think it shows the flow of...

No, good info.  Actually we have those comment sections as well, it's just that when someone from another department is standing over a dev's shoulder and they're having to adjust...

First run...

I ran it against a fairly messy stored procedure...multiple comment sections, aliased table names, updates & executes in the same proc, etc.  Here's what it extracted:

 1            Exec EventTracking.dbo.spProcessLogINS

 2            Update...

Thanks for the link.  I've actually began writing something that so far seems like it may do what I want.  I'm currently putting it together in a VB application, but...

Got two cats already, that's part of the deal, the new guy gets two cats.

Excellent! 

We just brought on a couple of contractual workers to help with the current workload, so if you were local (Central IL) there's a strong chance you could have helped....

Heh, if only it were that easy.  Since they're book (and I mean tightly) until at "least" the end of the year, that just isn't happening.

Unfortunately, time to market is...

Well, we're talking about more than 100 databases, with thousands of stored procedures built over the last 5 years by 15 or so developers, so the structure of them varies...

LOL that's ok. 

Coalesce(@PartID, 1)

That'll give you 1 if it's null, and @PartID if it isn't.

Hey some replies.

How much of a performance hit do you usually see with the profile running?

I'm trying to clean up some indexes on a warehouse database....

I believe another drawback to the Lumigent tool is that it only works on SQL2k installations.