Comments
Sort by recent activity
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...
Hi Dan, Thanks for reaching out to Redgate Support and sorry to hear you are having some trouble with your SQL Prompt install after updating to the latest version. Version 11 of Prompt was designed to support Azure Synapse Dedicated Pools, so likely something is not playing nominally with that interaction in your environment post update. In this case, we are troubleshooting this locally, so you may benefit from uninstalling and reinstalling the previous version of Prompt so that you can continue working in the meantime. You can find the link to our installation media HERE: https://download.red-gate.com/checkforupdates/SQLPrompt/ Can you try uninstalling and reverting one version and then let us know if that fixes you temporarily? Best, Christian Perez / comments
Official comment
Hi Dan, Thanks for reaching out to Redgate Support and sorry to hear you are having some trouble with your SQL Prompt install after updating to the latest version. Version 11 of Prompt was designed...
Hi Magnus, As Jane L. Lovett kindly mentioned, this is likely a permissions issue in your environment. You can find a full list of the required permissions for SQL Prompt on the following webpage: https://documentation.red-gate.com/sp/getting-started/requirements/sql-server-permissions However the key permissions are: User granted SELECT & VIEW DEFINITION on a database User granted VIEW ANY DEFINITION User is a member of the sysadmin role User is granted VIEW SERVER STATE Can you confirm you have the above permissions set and let us know if the behavior changes? / comments
Official comment
Hi Magnus, As Jane L. Lovett kindly mentioned, this is likely a permissions issue in your environment. You can find a full list of the required permissions for SQL Prompt on the following webpage: ...
Hi Terry, Thanks for reaching out to Redgate Support, sorry to hear you are having some trouble with your SQL Prompt installation. In this case, since your shared snippets appear to be missing you may need to re-login to RedgatePlatform. If you click on SQL Prompt > in SSMS, do you see an option for “Login to Redgate Platform”? If so go ahead and click on that and login and then see if your shared snippets return. / comments
Official comment
Hi Terry,Thanks for reaching out to Redgate Support, sorry to hear you are having some trouble with your SQL Prompt installation. In this case, since your shared snippets appear to be missing you m...
Hi James, Hope this finds you well, thanks for reaching out to Redgate Support regarding your issue with Compare. In this case, is the de-select all options not sufficient for your use-case? As for refreshing the comparison, it already behaves in the manner you describe, if I select only a few objects from below comparison and then hit refresh, the same objects are selected after the comparison is completed. [image] If the above is not what you are referring to, could I kindly request a screenshot of the behavior in question? / comments
Official comment
Hi James, Hope this finds you well, thanks for reaching out to Redgate Support regarding your issue with Compare. In this case, is the de-select all options not sufficient for your use-case? As for...