November 30, 2004 at 10:54 am
Is there any tool that generates some kind of diagram
or something?
Let's say I have 20 stored procedures
and I need to know what objects they reference.
I know I can get this info from sysobjects
but I would like to have a nice diagram or
something like that.
November 30, 2004 at 11:00 am
I've heard of tree representation but never of diagrams.
But this can get you started :
exec sp_depends 'SP_name'
November 30, 2004 at 11:02 am
Tree is fine.
Do you know which tool it is?
November 30, 2004 at 11:07 am
You can try this one for starters (may need to modify it a bit)
http://www.sqlservercentral.com/scripts/contributions/445.asp
November 30, 2004 at 11:09 am
forget that post.. that one is for foreign keys 🙁
November 30, 2004 at 11:14 am
This seems to be what you are looking for.
http://www.sqlservercentral.com/scripts/contributions/1212.asp
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply