Comments
Sort by recent activity
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...
HI James, Thanks for reaching out to Redgate Support regarding this SQL Source Control behavior you are seeing. Reviewing through that error, I think you may find use from the following troubleshooting article on partition schemes not being located. There is also some information about partition functions in this article, could you try the steps and let me know if the behavior changes? https://productsupport.red-gate.com/hc/en-us/articles/360007874773-The-partition-scheme-xxx-on-table-yyy-was-not-found / comments
HI James,Thanks for reaching out to Redgate Support regarding this SQL Source Control behavior you are seeing. Reviewing through that error, I think you may find use from the following troubleshoot...