Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Building Parent-Child Table Tree information Expand / Collapse
Author
Message
Posted Thursday, July 10, 2008 3:08 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, April 4, 2014 4:40 PM
Points: 751, Visits: 917
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
Posted Thursday, July 10, 2008 8:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 1:47 AM
Points: 7, Visits: 126
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
Posted Friday, July 11, 2008 1:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 7:00 AM
Points: 24, Visits: 278
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
Posted Sunday, July 13, 2008 7:30 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 12:46 AM
Points: 5,343, Visits: 1,387
Nice stuff......


Post #533137
Posted Monday, July 14, 2008 1:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, March 7, 2011 3:15 AM
Points: 375, Visits: 1,255
nice article and very helpful too.

Cheers!

Sandy.


--
Post #533312
Posted Wednesday, February 11, 2009 9:30 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 12:07 AM
Points: 21, Visits: 45
Thnks buddies its grt stuff. it just saved my lot of time.
Post #655381
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse