What is sort order in Dependencies Tree ?

Visualizes SQL Server object dependencies.

What is sort order in Dependencies Tree ?

Postby msq » Thu Aug 03, 2006 10:40 am

What order are objects sorted in the "Uses" section of the Dependencies tree ? I would have expected them to be either in the same order as they are accessed by the calling object or possibly in alphabetical order. However, they appear to be sorted in a random order.

If you are tracking the operation of a stored procedure by using Dependency Tracker, then it is important to know the order in which objects are accessed, otherwise the outcome would be completely different.
Posts: 4
Joined: Thu Jul 20, 2006 2:54 pm

Postby Brian Donahue » Thu Aug 03, 2006 2:58 pm

Dependency Tracker simply arranges the objects so that they fit in the grid. It uses an algorithm for doing so which is not specifically designed to sort SQL server objects, but rather to keep related objects together as closely as possible. There are a number of layout options, but none of them consider any aspect of the SQL object other than how close related objects should be.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Postby msq » Fri Aug 04, 2006 12:02 pm

That's a shame, as I think the order in which objects appear has a relevance. If you are looking at the objects used by a stored procedure, the order in which they are called/referenced determines the whole operation of the stored procedure.

Could I suggest that a sort option be provided in a later version of the product. Alternatives could include alphabetic and logical order.
Posts: 4
Joined: Thu Jul 20, 2006 2:54 pm

sort order would be very good

Postby jroh » Tue Jul 21, 2009 6:54 pm

I would also like to see the used by / uses objects sorted by name. I'm working with a db with many SP's tied to one table
Posts: 10
Joined: Thu Aug 21, 2008 3:15 pm

Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests