SQL Prompt and Linked Servers

01011010

When will this feature work again and will if every work permanently. Other vendors (devart sql complete) don't seem to have issues with this feature.

version 9.5.16.11294

Pete_Ruiz

Hi @01011010 ,

So sorry that you're not happy with SQL Prompt's support for linked servers. Is there a specific issue you're having with the feature? I've checked internally and we would expect that the feature should be working. Do you have an open case or current example of the feature not working that I can investigate?

Kind regards,

Pete Ruiz

Product Support

01011010

No open case.

Works up to this point 
SELECT * FROM act2.PAS_HCL_PROD.dbo.

no suggestions after dbo.

Pete_Ruiz

Hello @01011010 ,

Thanks for clarifying. Just to confirm, do you have the option to load suggestions for linked servers enabled in your SQL Prompt connection options?

​

Also, does the current user you're signed on as have the VIEW ANY DEFINITION permission on the linked server?  For more information on this, please see the documentation page below.

https://documentation.red-gate.com/sp/troubleshooting/common-issues/sql-prompt-is-not-showing-all-linked-servers

Kind regards,

Pete Ruiz

Product Support

01011010

The option is selected and the permission has been granted.

Pete_Ruiz

Hello @01011010,

We've just tested this feature in the latest version and it seems to be working as expected. If you test the connection to the linked server in SSMS, does the connection pass? Did the server name come up in the suggestions after the SELECT statement?

Kind regards,

Pete Ruiz

01011010

Thanks Pete, the autocomplete stops after the Database selection.

Note Linked server ACT2

Pete_Ruiz

Hello @01011010 ,

We've logged a support ticket for you so that we can help troubleshoot the issue. Can you please confirm that you've gotten the support email and respond there?

Kind regards,

Pete Ruiz