Comments
Sort by recent activity
Harman said:
Hi I have the same issue. That is, the suggestions for the Synonyms is not working. I am using a simple setup with 2 Databases on 1 Server. When using a SELECT statement from the Synonym table it shows the following on hovering. [image] [image] [image] [image] But upon execution works perfectly fine to display the records. I checked the settings as you mentioned above. [image] [image] Please help in resolving this issue. Thank you for your support in advance. Harman[image] [image]
Hey Harman, The problem was how I connected to the SQL instance in SSMS and how the synonyms were configured. If you have synonyms pointing to DATABASE.SCHEMA.TABLE, but you connect to your SQL instance using DATABASE.DOMAIN_NAME, this issue occurs. You must connect to your SQL instance using the same name that your synonyms reference. Hope this helps. @Kurt_M, can this be handled in SQL Prompt at all? / comments
Harman said:
HiI have the same issue. That is, the suggestions for the Synonyms is not working.I am using a simple setup with 2 Databases on 1 Server.When using a SELECT statement from the Sy...
Thanks for the suggestion @Kurt_M, but I have those three items selected, and am not using the option to "Only load suggestions for certain databases/schemas". / comments
Thanks for the suggestion @Kurt_M, but I have those three items selected, and am not using the option to "Only load suggestions for certain databases/schemas".