How can we help you today? How can we help you today?

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
davidmgray
0

Comments

5 comments

Sort by
  • James B
    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?
    James B
    0
  • davidmgray
    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
    davidmgray
    0
  • James B
    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.
    James B
    0
  • davidmgray
    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.
    davidmgray
    0
  • James B
    Awesome, thanks for posting back and letting us know!
    James B
    0

Add comment

Please sign in to leave a comment.