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

Synonyms and SQL Prompt not working as expected

We're using SQL Prompt with SQL Server 2012.

We have synonyms setup in our database which point to databases on the same server, and on different servers. When we use SQL prompt to view the field list for tables on different servers, SQL prompt does not display the list of fields. However when the synonym is to a database on the same server as the one we are connected to, it does display the field list. Is this a bug that could be resolved? See screenshots below of behavior

Screenshot of synonym to database on a different server than the one connected to
9i99uulx317t.png

Screenshot of synonym to database on same server as the one connected to
n1t64i7c3avk.png
ZackS
0

Comments

5 comments

Sort by
  • FabiolaB
    Hi @ZackS,

    Thank you for reporting this. We've reproduced the problem locally and created a bug (reference: SP-6559) to track it.

    Best regards,
    Fabiola
    FabiolaB
    0
  • ZackS
    I'm looking to purchase 5-6 licenses of sql prompt, but this bug is probably a deal breaker. What is the chance of fixing this in the next month or so?
    ZackS
    0
  • KiranP
    Hi @FabiolaB ,
    We have got a similar issue as well, keen to know by when we can get this fix.


    KiranP
    0
  • James R
    Hi all,

    I'm looking into this now and just want to double check a few things.
    1. Do you have the SQL Prompt > Options > Connections > Load referenced databases option selected?
    2. What type of remote servers are you referencing in your synonyms. Are they linked servers to the current server?

    Thanks for the help!
    James
    James R
    0
  • KiranP
    Hi @James R thanks for that, it works now.
    KiranP
    0

Add comment

Please sign in to leave a comment.