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

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

Screenshot of synonym to database on same server as the one connected to


Sign In or Register to comment.