Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jesse McLain Parse the dependency chain of an object RE: Parse the dependency chain of an object
jacob sebastian
SSChampion
Points: 11822
More actions
September 17, 2008 at 9:36 pm
#873366
Good post!
Another option is to use a recursive CTE that returns the entire dependency chain in a single query. I wrote such a function and the code is posted here: http://www.sqlserverandxml.com/2008/09/find-dependent-objects-recursively.html
.