Comments
Sort by recent activity
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...
Hi James, Appreciate all the feedback here. The whitespace being inserted is likely something on Compares script generation engine, of which I do not see a manner to manipulate the amount of whitespace. Maybe we can have better luck if we look at any changes performed recently to the application, was this behavior something you started seeing after performing an update to the product? / comments
Hi James, Appreciate all the feedback here. The whitespace being inserted is likely something on Compares script generation engine, of which I do not see a manner to manipulate the amount of whites...