Options
Synonyms and SQL Prompt not working as expected
ZackS
Posts: 3 New member
in SQL Prompt
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
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
Tagged:
Comments
Thank you for reporting this. We've reproduced the problem locally and created a bug (reference: SP-6559) to track it.
Best regards,
Fabiola
We have got a similar issue as well, keen to know by when we can get this fix.
I'm looking into this now and just want to double check a few things.
Thanks for the help!
James
Redgate Software