Options
Popup Suggestions on Linked Server not working
houstonc
Posts: 4 Bronze 1
With SQL Prompt 7.4.1.603.
Typing SQL that references tables within a Linked server is no longer working. Worked with 7.3.1.x.
Given the following SQL.
Have noticed that when I first use the LinkedServer.RemoteDB, the white box pops up saying connecting to RemoteDB but never see the progress meter show any green color like it connected and is pulling in the meta data.
Note: the LinkedServer has it's own remote user id and password so if SQL Prompt is trying to connect to the Linked Server as my connection, it will fail.
Typing SQL that references tables within a Linked server is no longer working. Worked with 7.3.1.x.
Given the following SQL.
SELECT * FROM LinkServer.RemoteDB.Owner.TableThe popup with relevant information is not working after I type the period after RemoteDB or even after I type in dbo followed by period.
Have noticed that when I first use the LinkedServer.RemoteDB, the white box pops up saying connecting to RemoteDB but never see the progress meter show any green color like it connected and is pulling in the meta data.
Note: the LinkedServer has it's own remote user id and password so if SQL Prompt is trying to connect to the Linked Server as my connection, it will fail.
Comments
Thanks for your post! This is a known issue, we have a fix for it locally and are hoping to release a new build containing the fix within the next few days.
Regards,
James
Redgate Software
We have just released the new stable build 7.5.0 which has a fix for this issue! See viewtopic.php?f=169&t=80730 for more information.
Please let us know if this fixes your issue
Thanks,
James
Redgate Software
Thank you for the support!