Red Gate forums :: View topic - unable to get list of column dependencies
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

unable to get list of column dependencies

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



Joined: 21 Apr 2009
Posts: 1
Location: Charleston, SC

PostPosted: Tue Apr 21, 2009 9:18 pm    Post subject: unable to get list of column dependencies Reply with quote

I did a search in SQL Dependency Tracker for a column name and it only returned objects with the column name in them. I would very much like for SQL Dependency Tracker to list dependencies at the column level.

I saw a post from 2007 (http://www.red-gate.com/messageboard/viewtopic.php?t=5829) where a moderator said this had been noted as a request. Is that request still active, and if so can you please add another voice of support for it?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Fri Apr 24, 2009 3:07 pm    Post subject: Reply with quote

Hi Charles,

I've added you to the list of requesters for SQL Dependency Tracker to support information about columns. The feature request that Eddie had originally opened is still waiting for review.
Back to top
View user's profile Send private message
jasolution



Joined: 07 Oct 2008
Posts: 8

PostPosted: Tue May 26, 2009 6:41 pm    Post subject: Reply with quote

This would indeed be most helpful. In fact, this is the only function I'd hoped to achieve with Dependency Tracker. Smile
Back to top
View user's profile Send private message
rgribble



Joined: 04 Apr 2005
Posts: 67

PostPosted: Wed Jun 17, 2009 1:22 am    Post subject: Reply with quote

Same here. We hadnt really looked at this tool, but recently had need to find everywhere in the schema that referenced a particular column. We fired up SQL Dependency Tracker but found it can only show us at a table level with no option to find dependencies on a column.

This is the sole function we turned to Dependency Tracker for, so it would definitely be a great addition.

Please add me to the list of requesters for this feature
Back to top
View user's profile Send private message
bbate



Joined: 02 Aug 2010
Posts: 2

PostPosted: Mon Aug 02, 2010 8:00 pm    Post subject: Re:unable to get list of column dependencies Reply with quote

Brian Donahue wrote:
Hi Charles,

I've added you to the list of requesters for SQL Dependency Tracker to support information about columns. The feature request that Eddie had originally opened is still waiting for review.


Any update on the status of this feature request (or whether it has already been added and I don't know it Smile )?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Mon Aug 02, 2010 8:08 pm    Post subject: Reply with quote

This is a feature that we hope to add to SQL Prompt 5, due out fairly soon (let me know if you want to be added to the early adopter list). However, this won't display the information in graphical form, just as a list. Would this be an issue?

For the time being, it is possible to get a list of dependent objects by going through the Smart Rename process for a column using SQL Refactor, as this shows you which objects will be affected by the change!

David Atkinson
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
bbate



Joined: 02 Aug 2010
Posts: 2

PostPosted: Mon Aug 02, 2010 8:15 pm    Post subject: Re: Reply with quote

David Atkinson wrote:
This is a feature that we hope to add to SQL Prompt 5, due out fairly soon (let me know if you want to be added to the early adopter list). However, this won't display the information in graphical form, just as a list. Would this be an issue?

For the time being, it is possible to get a list of dependent objects by going through the Smart Rename process for a column using SQL Refactor, as this shows you which objects will be affected by the change!

David Atkinson
Red Gate Software


Thanks for the quick reply, David. Not having the graphical detail would not be a problem. I would just need the text to serve as an inventory of potential impact caused by changes between databases.

In the meantime,I appreciate the tip about using SQL Refactor to get the information I need. Thanks!
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