Comments
Sort by recent activity
With respect to toggling intellisense, if you click on SQL Prompt and then click on refresh suggestions or ‘Enable Suggestions’ that should force a reconnect to be attempted by Prompt to load suggestions. Are you using Entra MFA authentication with this dedicated pool by chance? / comments
With respect to toggling intellisense, if you click on SQL Prompt and then click on refresh suggestions or ‘Enable Suggestions’ that should force a reconnect to be attempted by Prompt to load sugge...
File Request You can submit the logs here for review. Please visit the following URL to send us files: https://files.red-gate.com/requests/UQm85OngUpGVd7TgPkZqX3 This link expires: Friday, 27 June. / comments
File Request You can submit the logs here for review. Please visit the following URL to send us files: https://files.red-gate.com/requests/UQm85OngUpGVd7TgPkZqX3 This link expires: Friday, 27 June.
Hi Paul, Sorry to hear you are also being impacted by the Prompt defect where it does not appear in SSMS 21, in my troubleshooting with other customers we have found that when the Prompt menu was not appearing for them, we deleted SSMS 21 and SQL Prompt along with Prompts AppData Directory (Users/christian.perez/appdata/local/Red Gate/SQL Prompt), after that we installed SSMS 21 first on the default C drive, after that we installed SQL Prompt 11.0.2 on the default C Drive (for testing) and it was at this point that we were able to see the SQL History button appear in SSMS 21 and then we were able to see both SQL Prompt options appear in the Extensions Costumization dropdown. If you try the above steps are you still not seeing the menu dropdown? / comments
Hi Paul,Sorry to hear you are also being impacted by the Prompt defect where it does not appear in SSMS 21, in my troubleshooting with other customers we have found that when the Prompt menu was no...
To piggy back off of Walter, once we installed SQL Prompt and SSMS on the C Drive and confirmed we could see it in the context menu of SSMS, we were able to then uninstall, move the Prompt installation location back to the D drive, and then reinstall Prompt and the Context Menu remained. We are investigated why the initialization does not appear to be working nominally when not installed on the C drive or when SSMS and Prompt are installed initially on different drives. / comments
To piggy back off of Walter, once we installed SQL Prompt and SSMS on the C Drive and confirmed we could see it in the context menu of SSMS, we were able to then uninstall, move the Prompt installa...
Thanks Walter, I have this behavior escalated with the Prompt team to fix the installer issues when SSMS 20 and 21 are side by side or installed on a different drive than one another, have you already tried the steps mentioned by Curtis to get Prompt to appear in the toolbar again?
Extensions | Customize Menus…
Uncheck both SQL Prompt boxes
Close SSMS
Open SSMS | Extensions | Customize Menus
Check second SQL Prompt box
Restart SSMS
If I am understanding you correctly, in your case, you do not have any SQL prompt boxes to check off when you click the Extensions Customize Menu? As Curtis mentioned SSMS 21 switches from a 32 bit to a 64bit architecture and as a result, should be much improved and faster to use once these teething issues are resolved. / comments
Thanks Walter,I have this behavior escalated with the Prompt team to fix the installer issues when SSMS 20 and 21 are side by side or installed on a different drive than one another, have you alrea...
Good Morning Dan, Thanks for your patience here, I do believe that we have some remediation steps ready for this behavior. We released version 11.0.2 of Prompt this morning and I was able to test this private build yesterday and it worked for me. The steps in this case would be to install the new version of Prompt and then afterwards to grant the login user connecting the Synapse Dedicated Pool db_datareader permissions. In my instance I used the following stored procedure to make the change. https://download.red-gate.com/checkforupdates/SQLPrompt/ EXEC sp_addrolemember 'db_datareader', '<login_name>';
GO After elevating the permission for your login user, close SSMS, reopen and reconnect and observe if you are still having the issue. Let me know if you would like me to elaborate on any of the instrucitons listed here or if you are still seeing the same behavior after performing the steps. / comments
Good Morning Dan, Thanks for your patience here, I do believe that we have some remediation steps ready for this behavior. We released version 11.0.2 of Prompt this morning and I was able to test t...
Hi, Walter, What is the behavior that you are now running into when you are installing? Apologies for making you repeat yourself but this thread now carries a few issues and so I am not sure what issue is impacting you. / comments
Hi, Walter,What is the behavior that you are now running into when you are installing? Apologies for making you repeat yourself but this thread now carries a few issues and so I am not sure what is...
Hi Justin, Thanks for reaching out to Redgate Support, sorry to hear you are having some trouble with intellisense in SQL Prompt 11. We have had a few users who have had some issues Dedicated Pools after updating, could I trouble you for your SQL Prompt Log files so I can review them and confirm you are not also being impacted? (SQL Prompt > Help > Locate Log Files) Alternatively, I have heard a few users have success toggling intellisense on and off to get things going again. / comments
Official comment
Hi Justin, Thanks for reaching out to Redgate Support, sorry to hear you are having some trouble with intellisense in SQL Prompt 11. We have had a few users who have had some issues Dedicated Pools...
Hi Walter, Thanks for checking the version for us. As SelectStar mentioned, the latest version should automatically grab the settings from Prompt 10 and port them to Prompt 11. If that is not the case for you, what are you currently missing in your environment? I will likely have to try and replicate this. / comments
Hi Walter, Thanks for checking the version for us. As SelectStar mentioned, the latest version should automatically grab the settings from Prompt 10 and port them to Prompt 11. If that is not the c...
Hi Rasmus, Thanks for letting us know you are still having issues with the latest release, could you let me know where you currently are in terms of this issue? Are you now getting the Prompt dropdown in the application, is Prompt just not working for you since you installed SSMS 21 on another drive than default? Lets see if we cannot get this fixed for you guys or at least sent up to development if a patch release is needed. Also are you currently on 11.01? / comments
Hi Rasmus,Thanks for letting us know you are still having issues with the latest release, could you let me know where you currently are in terms of this issue? Are you now getting the Prompt dropdo...