Red Gate forums :: View topic - What is sort order in Dependencies Tree ?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

What is sort order in Dependencies Tree ?

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
msq



Joined: 20 Jul 2006
Posts: 4

PostPosted: Thu Aug 03, 2006 11:40 am    Post subject: What is sort order in Dependencies Tree ? Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Thu Aug 03, 2006 3:58 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
msq



Joined: 20 Jul 2006
Posts: 4

PostPosted: Fri Aug 04, 2006 1:02 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
jroh



Joined: 21 Aug 2008
Posts: 10

PostPosted: Tue Jul 21, 2009 7:54 pm    Post subject: sort order would be very good Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group