SQL Prompt Error No sever for this candidate

• 
  I got the same issue and for the second week, it is going to be really annoing. Every time I'm writing "something." got an error message for reporting the bug to redgate. Believe me, I reported it many times and many times just close the window. "Red Gate" pls fix or help in another way as to turn off suggestions.

  andrejzafka August 20, 2021 14:29

  - 0 +
• 
  Same here and reported it too.

  Digga August 23, 2021 10:02

  - 0 +
• 
  I hope this gets fixed soon. This is real annoying.

  PaulStevens August 23, 2021 16:48

  - 0 +
• 
  Happening here as well. Please fix.

  Gail September 01, 2021 13:08

  - 0 +
• 
  Hi @...,

  
  

  Thanks for reaching out to us regarding this! Our apology for the delay in responding to you!

  
  

  Looking at the other comments on this thread this appears to be affecting others also.

  
  

  I'm currently trying to replicate the issue you are seeing here, but have so far been unable to do so. Just to check, do you only see this issue in the latest version of SQL Prompt (v.10.7.1)?
  

  Dan_J September 01, 2021 14:40

  - 0 +
• 
  Happened just before I created the ticket. It happens when using #tavbles.

  Gail September 01, 2021 15:23

  - 0 +
• 
  Hi @Dan_J,
  
  Thank you for your response. Yes, this issue started only with SQL Prompt((v.1.0.7.1).  Also, the popup error is not just occurring with references #temp tables. It also occurs with stated tables as well.

  FFerguson September 01, 2021 15:52

  - 0 +
• 
  Hi @FFerguson
  

  
  

  Thanks for your quick response on this!
  

  
  

  Since my last update on this thread I have been made aware that a fix for this issue is close to being released. I will let you know as soon as the next version of SQL Prompt is released.
  

  Dan_J September 01, 2021 16:04

  - 0 +
• 
  I am experiencing the same issue, when would this be fixed? It is really annoying! 

  afernandez September 01, 2021 16:26

  - 0 +
• 
  I'm getting the same issue, it is really annoying.  I just started when I upgraded to the latest version.

  gregers September 02, 2021 14:54

  - 0 +
• 
  Same here
   SQL Prompt (v.10.7.1) - SSMS 18.9.2
  is there a hotfix/workaround available (aside from disabling SQL prompt) - this is getting real annoying

  Koenraad.Dendievel September 06, 2021 07:42

  - 0 +
• 
  Hi all,

  
  

  As our development team are yet to release the fix for this issue, I think it might be worth downgrading to SQL Prompt v.10.7.0 so that you stop encountering this issue for now. It's then worth keeping an eye out for when SQL Prompt suggests updating to v10.7.2 (which will contain the fix).
  
  V.10.7.0 can be downloaded here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.7.0.22192.exe
  
  I hope this helps for now!
  

  
  

  Dan_J September 06, 2021 13:50

  - 0 +
• 
  Ok, I see, but, for downgrade will stay my settings? What about to connections from source control to databases? After last upgrade I lost all my connections and snippets. I don't want to setup all after downgrade.

  andrejzafka September 06, 2021 15:49

  - 0 +
• 
  Downgrading didn't solve the problem.  I had to completely uninstall SQL Prompt.

  TimG5 September 07, 2021 04:36

  - 0 +
• 
  I have downloaded the older version linked by Dan_J, uninstalled 10.7.1 and installed 10.7.0 but the problem persists. Has it corrupted the SQL Prompt settings or something?

  nharris18 September 07, 2021 16:42

  - 0 +
• 
  Hi all,

  
  

  Our SQL Prompt team have now released an update which contains a fix for this issue. V.10.7.2 can be downloaded here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.7.2.22957.exe
  
  It would be appreciated if you could confirm that this update does resolve this issue for you.

  
  

  Also to mention, downgrading will not cause your settings to be lost. Saying that, it is advisable to take a backup of your Snippet/Style files as a precaution.
  

  
  

  Dan_J September 08, 2021 09:29

  - 0 +
• 
  I have uninstalled the previous version I had installed (10.7.0 , but still erroring) and installed 10.7.2 and I still have the problem

  nharris18 September 08, 2021 11:49

  - 0 +
• 
  I'm sorry to say it, but I installed version 10.7.2 and the problem still persist.

  andrejzafka September 08, 2021 11:52

  - 0 +
• 
  The problem still exist.  When I alias a table, let's say with a two letter alias, and then proceed to use reference that two letter alias in the where clause, before I get done with typing the two letter alias, an error message screen displays stating that "No server found for this candidate"

  gregers September 08, 2021 15:02

  - 0 +
• 
  Hi all,

  
  

  Thank you for your feedback on this!

  Our development team identified that further work that was required to resolve this issue for all scenario's. They have subsequently released SQL Prompt v.10.7.3, which can be downloaded here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.7.3.23021.exe

  Again, it would be greatly appreciated if you could confirm that this latest release does indeed fix this issue for you.

  
  

  Thank you for your patience with us on this.
  

  
  

  Dan_J September 09, 2021 09:29

  - 0 +
• 
  Thanks Dan, I can confirm version 10.7.3 has resolved my issues.

  Digga September 09, 2021 09:33

  - 0 +
• 
  Fixed it for me! 
  
  Thank you (and the dev team...).

  nharris18 September 09, 2021 09:36

  - 0 +
• 
  It appears to have been fixed!!!
  
  Thank you

  gregers September 09, 2021 15:30

  - 0 +
• 
  Fixed! Thanks!

  andrejzafka September 10, 2021 06:24

  - 0 +
• 
  That's great, I'm glad this latest fix has resolved this issue for you! @FFerguson, is this the same for you also?
  

  Dan_J September 13, 2021 08:56

  - 0 +

Add comment

Please sign in to leave a comment.