How can we help you today? How can we help you today?

Popup Suggestions on Linked Server not working

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.
houstonc
0

Comments

3 comments

Sort by
  • 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
    0
  • 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
    James R
    0
  • houstonc
    Yay. The new release of SQL Prompt 7.5.0.787 has fixed my issue.

    Thank you for the support!
    houstonc
    0

Add comment

Please sign in to leave a comment.