SQL Prompt and Linked Servers

• 

  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
  

  Pete_Ruiz September 17, 2019 16:08

  - 0 +
• 
  No open case.
  
  Works up to this point 
  SELECT * FROM act2.PAS_HCL_PROD.dbo.
  
  no suggestions after dbo.
  
  

  01011010 September 17, 2019 16:44

  - 0 +
• 

  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
  

  Pete_Ruiz September 19, 2019 19:14

  - 0 +
• 
  The option is selected and the permission has been granted.
  
  

  01011010 September 23, 2019 14:38

  - 0 +
• 
  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
  

  Pete_Ruiz September 30, 2019 16:41

  - 0 +
• 
  Thanks Pete, the autocomplete stops after the Database selection.
  
  Note Linked server ACT2
  
  
  

  01011010 October 01, 2019 06:41

  - 0 +
• 
  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
  

  Pete_Ruiz October 03, 2019 22:14

  - 0 +

Add comment

Please sign in to leave a comment.