Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

Synonyms and SQL Prompt not working as expected

ZackSZackS Posts: 3 New member
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
Tagged:

Comments

Sign In or Register to comment.