| Author |
Message |
davidmgray
Joined: 31 May 2007
Posts: 13
Location: UK
|
 Posted: Wed Jun 15, 2011 11:58 am Post subject: Same table in two seperate schemas |
 |
|
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 |
|
 |
james.billings
Joined: 16 Jun 2010
Posts: 864
Location: My desk.
|
| Posted: Thu Jun 16, 2011 2:02 pm Post subject: |
|
|
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 |
|
|
davidmgray
Joined: 31 May 2007
Posts: 13
Location: UK
|
| Posted: Thu Jun 16, 2011 3:05 pm Post subject: Re: |
|
|
| 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 |
|
|
james.billings
Joined: 16 Jun 2010
Posts: 864
Location: My desk.
|
| Posted: Thu Jun 16, 2011 3:07 pm Post subject: |
|
|
| 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 |
|
|
davidmgray
Joined: 31 May 2007
Posts: 13
Location: UK
|
| Posted: Thu Jun 16, 2011 3:29 pm Post subject: Re: |
|
|
| 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 |
|
|
james.billings
Joined: 16 Jun 2010
Posts: 864
Location: My desk.
|
| Posted: Thu Jun 16, 2011 3:31 pm Post subject: |
|
|
| Awesome, thanks for posting back and letting us know! |
|
| Back to top |
|
|
|
|
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
