Navigating SQL Server nested stored procedures

[woohoo]

I'm working with some really nasty nested stored procedures.

Is there a tool or add-in that would allow me to see a graphical representation of a stored procedure and any nested sprocs. Ideally, I would then like to click on any of the nested sprocs and be taken to the code.

The idea is that I could open the graphical representation in another window and use it to work my way around the sp.

Thanks in advance.

[quackhandle]

Off the top of my head I seem to recall one of the red gate SQL tools being able to do this.

qh

[ribble]

Try Compare SQL Server Databases - DBA xPress

[woohoo]

Try Compare SQL Server Databases - DBA xPress

Great will take a look at it!

I'm looking at SQL Dependency tracker from Redgate (quackhandle pointed me in this direction), it's close to what am after but seems a little clumsy for what I want to do.

Cheers