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

Schema and Linked Server with same name

I'm working in SSMS in a database that contains a schema (prod) the same name as a linked server (PROD). After I type "select * from pr" and bring up the pop-up list, I select the schema "prod", then type "." and bring up the pop-up list again. The pop-up list always says No Suggestions even though there are tables in the schema.

I do have cross database and linked server option checked because I use the cross-database support within the same server instance.

Is there another way to get the table list for the schema?

Thanks,
Traci
tkdennis
0

Comments

3 comments

Sort by
  • tanya
    Hi Traci,

    I did try this and it seems to work fine for me.
    Can you trying making sure if your cache is refreshed? You can do this by clicking on SQL Prompt menu - Refresh cache.
    Let me know if it still continues to be an issue.

    Thanks,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0
  • tkdennis
    Yes, I did try refreshing the cache, then deleting everything in the cache, with no luck. The only thing that worked was deleting the linked server.

    Thanks,
    Traci
    tkdennis
    0
  • tanya
    Hi Traci,

    I have logged this issue into our bug database. We are currently working on supporting SQL 2008 platform and after that we should be able to investigate into this issue.
    I will keep you posted with updates.
    Excuses for any inconvenience caused.

    Thanks,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0

Add comment

Please sign in to leave a comment.