Best Of
Re: SQL Prompt Error '.', hexadecimal value 0x00, is an invalid character. Line 1, position 1.
Hi all, i had same problem after i accidentally hit the power switch.
To fix the issue without re-installing SQL Prompt what I did was
1) Exit SQL Management studio
2) Go to folder C:\Users\myuser\AppData\Local\Red Gate\SQL Prompt 10\
3) Rename the file (to test it first) RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml to something else like RedGate_SQLPrompt_CommonUI_Options_UIOptions_old.xml
4) Run SQL Management studio
This will then re-generate this file. It seems this file got corrupted (i.e. its empty) once i run it up and worked I removed renamed file
To fix the issue without re-installing SQL Prompt what I did was
1) Exit SQL Management studio
2) Go to folder C:\Users\myuser\AppData\Local\Red Gate\SQL Prompt 10\
3) Rename the file (to test it first) RedGate_SQLPrompt_CommonUI_Options_UIOptions.xml to something else like RedGate_SQLPrompt_CommonUI_Options_UIOptions_old.xml
4) Run SQL Management studio
This will then re-generate this file. It seems this file got corrupted (i.e. its empty) once i run it up and worked I removed renamed file

6 ·
Re: Will SCA support Visual Studio 2022
Any update on this matter?StephanieHerr said:Hi.
The team is currently working on this and have met with the SQL Prompt team to learn about the issues they faced with supporting this new version. We have a catch-up on Mon and I hope to know more then. I'll add a reminder on my calendar to post another update then.
Thanks for chasing this.

6 ·
Can SQL Source control screen in SSMS utilise the 'Dark Theme'
For disability reasons I have utilised the 'Dark Theme' in SSMS. This gives me a black background and white text. I know this is not truly supported by Microsoft but is easily enabled by editing the ssms.pkgundef.
Is there any chance that Source Control screens could utilise the same colours. Currently I end up with a screen like below.

Is there any chance that Source Control screens could utilise the same colours. Currently I end up with a screen like below.


5 ·
Re: Prompt 9 Error in SSMS 18.5
Forced upgrade with no warning. Nice customer service. Grrr...

5 ·
SQL Prompt Error No sever for this candidate
I just updated to SQL Prompt 10.7 from 10.6 with SSMS 18.9. Each time I type a reference to the temp table or alias to one I get the error: "No server found for this candidate". This did not occur with version 10.6. Is there a setting to stop this error?

5 ·
Re: SQL Search text box grayed out in SSMS. How to resolve?
As woj123 said, I found just disconnecting from the server in SSMS's Object Explorer, then re connecting (via Registered Server makes this reasonably painless) fixes the issue. Looks like it is SQL Prompt's tab-auto re-connect that forgets to also do the SQL search tab

6 ·
Mac Support for SQL Prompt
Slightly disappointed that Redgate SQL Prompt doesn't work in ADS on the Mac - is there an intent to do so?

6 ·