What are the challenges you face when working across database platforms? Take the survey
Options

Schema and Linked Server with same name

tkdennistkdennis Posts: 114
edited July 10, 2008 4:40AM in SQL Prompt Previous Versions
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

Comments

  • Options
    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
  • Options
    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
  • Options
    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
Sign In or Register to comment.