Building Parent-Child Table Tree information

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Narasimhan... » Building Parent-Child Table Tree information

16 posts, Page 2 of 2

««1 2

Building Parent-Child Table Tree information

Rate Topic

Display Mode

Topic Options

Author

Message

timothyawiseman

Posted Thursday, July 10, 2008 3:08 PM

Right there with Babe

Group: General Forum Members
Last Login: Thursday, February 14, 2013 12:01 PM
Points: 743, Visits: 900

Very nice article, and very well done.

You can achieve similar functionality using sp_msdependencies if you like, but that requires using an undocumented stored procedure and the bit field can be slightly difficult to get right.

---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/

Post #531994

wyfccc

Posted Thursday, July 10, 2008 8:57 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 8:56 PM
Points: 7, Visits: 102

Greate!
But, in my routine, I often have to find the storeprocedure correlated to a table or column.
I have a script for purpose, but it just do it by key search.
Anyone have some good idea for it?

Post #532098

Cheetah

Posted Friday, July 11, 2008 1:24 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 22, 2013 3:26 AM
Points: 23, Visits: 246

Does somebody perhaps have the code for an dependence tree for all tables in the database.
ie Level 1 all tables with no dependencies, Level 2 all tables that depend on Level 1 and so on..
I can probably write it myself, but I have a time constraint, need to move data from one db to another and do some key conversions in between. So my order of processing the tables must be right.

Post #532185