Red Gate forums :: View topic - Same table in two seperate schemas
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

Same table in two seperate schemas

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



Joined: 31 May 2007
Posts: 13
Location: UK

PostPosted: Wed Jun 15, 2011 11:58 am    Post subject: Same table in two seperate schemas Reply with quote

Hi,
SQL 2005

I have two tables with the same name in different schemas. I would like to check the dependancies on one of them but it appears I'm unable to choose the schema.

Only one is shown in the list of selectable objects & it's not clear which one that is.

Am I missing something?

Dave
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1121
Location: My desk.

PostPosted: Thu Jun 16, 2011 2:02 pm    Post subject: Reply with quote

I just looked at the notest for the latest patch here and I see one of the changes was to Full-Qualify objects.
That sounds like it may help with your problem, so could you install it and see how you get on?
Back to top
View user's profile Send private message
davidmgray



Joined: 31 May 2007
Posts: 13
Location: UK

PostPosted: Thu Jun 16, 2011 3:05 pm    Post subject: Re: Reply with quote

james.billings wrote:
I just looked at the notest for the latest patch here and I see one of the changes was to Full-Qualify objects.
That sounds like it may help with your problem, so could you install it and see how you get on?


Hi,
Thanks I will give that a try. However it was not just that the schemas weren't being displayed, it was that when there were duplicate objects in two different schemas, only was was showing.

Dave
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1121
Location: My desk.

PostPosted: Thu Jun 16, 2011 3:07 pm    Post subject: Reply with quote

OK - if the patch doesn't work, let us know and I'll see if I can reproduce the problem at this end, and log a bug if needs be.
Back to top
View user's profile Send private message
davidmgray



Joined: 31 May 2007
Posts: 13
Location: UK

PostPosted: Thu Jun 16, 2011 3:29 pm    Post subject: Re: Reply with quote

james.billings wrote:
I just looked at the notest for the latest patch here and I see one of the changes was to Full-Qualify objects.
That sounds like it may help with your problem, so could you install it and see how you get on?


That's fixed it, many thanks.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1121
Location: My desk.

PostPosted: Thu Jun 16, 2011 3:31 pm    Post subject: Reply with quote

Awesome, thanks for posting back and letting us know!
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