Activity overview
Latest activity by Christian Perez
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...
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...