What is sort order in Dependencies Tree ?

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

What is sort order in Dependencies Tree ?

Postby msq » Thu Aug 03, 2006 11: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.
msq
 
Posts: 4
Joined: Thu Jul 20, 2006 3:54 pm

Postby Brian Donahue » Thu Aug 03, 2006 3: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: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby msq » Fri Aug 04, 2006 1: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.
msq
 
Posts: 4
Joined: Thu Jul 20, 2006 3:54 pm

sort order would be very good

Postby jroh » Tue Jul 21, 2009 7: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
jroh
 
Posts: 10
Joined: Thu Aug 21, 2008 4:15 pm


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests