Activity overview
Latest activity by itsmikeyd
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".
Synonyms - Suggestions are not working
Heya all,I've got a very strange scenario on my hands. I have two servers, SERVER1 and SERVER2. They both run SQL Server 15.0.2095.3. I am running SQL Prompt 10.13.4.32349 in SSMS 18.12.1.SERVER1 h...