Popup Suggestions on Linked Server not working

houstonc

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.

SELECT *
  FROM LinkServer.RemoteDB.Owner.Table

The 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.

James R

Hi houstonc,

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

James R

Hi again houstonc,

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

houstonc

Yay. The new release of SQL Prompt 7.5.0.787 has fixed my issue.

Thank you for the support!