Activity overview
Latest activity by Christian Perez
Hi Jon, Thanks for reaching out to Redgate Support regarding your SQL Prompt 11 inquiry. In this case, since you already have the old SQLHistory file, you would need to navigate to your C:\Users\<YOURUSER>\AppData\Local\Red Gate\SQL Prompt 11 directory and replace the existing SqlHistory database file with the file from the old PC. That should integrate your old SQL History into the new Prompt. / comments
Official comment
Hi Jon,Thanks for reaching out to Redgate Support regarding your SQL Prompt 11 inquiry. In this case, since you already have the old SQLHistory file, you would need to navigate to your C:\Users\<YO...
Hi Jason, Checking in to see if you were able to update to the current version? / comments
Hi Jason, Checking in to see if you were able to update to the current version?
Hi Christine, Hope you are doing well today, sorry to hear you are having a little trouble with your SQL Data Compare install. Can we start with confirming that you are able to connect to this database instance using SSMS + Windows Authentication outside of Data Compare? If that works without issue, could you share with me the full error output that you are getting in the screenshot you shared with us? / comments
Official comment
Hi Christine, Hope you are doing well today, sorry to hear you are having a little trouble with your SQL Data Compare install. Can we start with confirming that you are able to connect to this data...
Hi Dirk, Hope you are doing well today, sorry to hear you are having a little trouble with your SQL Prompt installation, if you click on SQL Prompt > Help > Locate log files, could I trouble you to attach those logs here for review? I should be able to determine what we need to focus on next with those. That being said, there are some known issues with suggestions in version 11 of prompt that are still being worked on by the developers, so I would also ask what kind of database are you attempting to connect to, is this an Azure Synapse Database or something else? / comments
Official comment
Hi Dirk, Hope you are doing well today, sorry to hear you are having a little trouble with your SQL Prompt installation, if you click on SQL Prompt > Help > Locate log files, could I trouble you to...
Hi Bryan, Thanks for reaching out to Redgate Support regarding your Source Control issues. I was able to discuss this a bit further with the developers and they have concluded that this does appear to be the newly expected behavior from Source Control in SSMS 21. While the behavior you were seeing was indeed not nominal when comparing to older versions of Source Control, with SSMS 21, the initial loading behavior has changed. As a result, the SOC page does not auto load when SSMS 21 starts. This affects the initialization of certain events responsible for updating icons. Now (SSMSv21 onwards), these events get triggered whenever the SOC page is opened manually or the SOC button is clicked. Workaround options for you include the following. (Either of these steps will trigger the event and then the connected database will be identified as expected)
In SSMS 21, connect to DB server then open(Click on) SOC tab and Refresh the DB server.
In SSMS 21, connect to DB server then open(Click on) SOC tab, Disconnect, and Reconnect the DB server.Cancel the connection dialog when SSMS 21 opens, open the SOC page first, and then connect to the desired DB server.
Let me know if you have any follow up questions or concerns. / comments
Official comment
Hi Bryan, Thanks for reaching out to Redgate Support regarding your Source Control issues. I was able to discuss this a bit further with the developers and they have concluded that this does appear...
Hi Justin, Thanks for following up, you will need to update to the latest version of Prompt since you are using Entra MFA, there was a fix put out in that version for Synapse Dedicated Pools and Entra MFA authentication. Keep in mind you will be prompted to accept permissions when you initially connect after updating Prompt that you will need to do, this may require an admin to approve. You can find the download link here: https://download.red-gate.com/checkforupdates/SQLPrompt/ / comments
Hi Justin, Thanks for following up, you will need to update to the latest version of Prompt since you are using Entra MFA, there was a fix put out in that version for Synapse Dedicated Pools and En...
Hi @... , we are aware of an issue with Synapse Dedicated Pools that use Entra MFA authentication still experiencing issues, however, the test build that I troubleshot this morning was successful in remediating that issue, so once the next release of Prompt goes out with this Private build I expect any remaining Synapse Dedicated Issues to abate for most users. Please be on the lookout for the next Prompt release on this page: https://download.red-gate.com/checkforupdates/SQLPrompt/ / comments
Hi @... , we are aware of an issue with Synapse Dedicated Pools that use Entra MFA authentication still experiencing issues, however, the test build that I troubleshot this morning was successful i...
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...