Best Of
Re: Anyone else have suggestions not working in latest update of SQL Prompt?
Ben_P said:The issue seems to be due to SSMS 19.3 using MDS 3.1.5 whilst SQL Prompt uses 3.1.1. Whilst the team work on a solution for this, it is recommended to use an earlier version of SSMS, such as 19.2 or 18.12.1. Users have also reported that downgrading SQL Prompt to 10.4.4 has worked for them:
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.4.4865.exe
Hi Ben - what's the solution for the latest issue where the column picker etc stopped working randomly and upgrading has not hellped?
Davidian
1 ·
Re: issue with seeing 'schema model'
Thank you for your insights and help, it turns out my colleague was not signed into his flyway. After signing in he was able to see the schema-model, thank you again!
Re: SQL Prompt Refreshing very slowly, different query when connecting to DB
Hi @MFrenzel
Thanks for chiming in, thankfully this issue has now since been replicated by development and they are currently testing the fix we are planning to implement. Once that has cleared smoke testing and is released in a new version of SQL Prompt, I will circle back here and let you guys know. Looking at the solution, it seems to be significantly faster after the fix is applied.
Cheers,
Christian Perez
Product Support
Thanks for chiming in, thankfully this issue has now since been replicated by development and they are currently testing the fix we are planning to implement. Once that has cleared smoke testing and is released in a new version of SQL Prompt, I will circle back here and let you guys know. Looking at the solution, it seems to be significantly faster after the fix is applied.
Cheers,
Christian Perez
Product Support
cperez
1 ·
Re: SmartAssembly 8 - "System.IO.FileNotFoundException: Could not load file or assembly" error
You're welcome. I'm glad the things I learned could be put to use helping someone else!
volbol
1 ·
Re: SQL Compare cannot transfer correctly PERIOD FOR SYSTEM_TIME and HIDDEN attributes
Hello again @Ivailo,
This issue has been logged as a bug by Development and is currently being worked on. Once work has concluded and I have next steps or a remediation available for you, I will circle back here an update you further.
Cheers,
Christian Perez
This issue has been logged as a bug by Development and is currently being worked on. Once work has concluded and I have next steps or a remediation available for you, I will circle back here an update you further.
Cheers,
Christian Perez
cperez
1 ·
Re: SQL Prompt 10.15.0.12121 Not Working in Visual Studio 2022
Hi all, This should now be fixed with the latest release, and this also includes a fix for an issue in SSM that caused multiple copies of the same query to be opened from SQL History:
10.15.3.12768 - Released on 26 November 2024
Fixes
- Fixed an issue where multiple instances of the same query tab opened by SQL History in SSMS.
- Fixed SQL Prompt (15.1) that caused an error to appear while opening in Visual Studio.
Ben_P
1 ·
Re: SQL Prompt does not Install into SSMS 21.0 Preview 1.0
Hi @JasonSelburg
Thank you for reaching out on the Redgate forums regarding your SSMS21 install.
We have the following blog post published regarding our support of SSMS V21:
https://productsupport.red-gate.com/hc/en-us/articles/23014007338909-SSMS-v21-and-your-Redgate-products
Thank you for reaching out on the Redgate forums regarding your SSMS21 install.
We have the following blog post published regarding our support of SSMS V21:
https://productsupport.red-gate.com/hc/en-us/articles/23014007338909-SSMS-v21-and-your-Redgate-products
As of now, SSMS v21 is still in Preview Release 1 and Redgate tools do not yet officially support this version. We're actively working to ensure our tools are compatible with SSMS v21 ahead of its General Availability (GA) release.
We recommend that users who rely on Redgate tools for their workflows continue to use the latest supported version of SSMS for now. Compatibility updates and announcements will be provided as we approach the GA release.
Jon_Kirkwood
1 ·
Toolbelt essentials say already installed but don't show in SSMS
Following a nasty crash on my laptop, I've reinstalled SQL Server 2019 and SSMS 2022. The Redgate Toolbelt items no longer appear in the SSMS toolbar and there is no option to add a toolbar for them. If I try to reinstall Toolbelt Essentials, it says that all items are already installed.
I've seen the advice for this problem on earlier versions and have tried removing SSMS 2022 and reinstalling SSMS 2019 (version 15.0.18424.0) and I've run a repair on SQL toolbelt, but it doesn't appear to make a difference.
Should I remove Toolbelt essentials and reinstall from scratch? Or is there a better fix available?
Thanks in anticipation.
I've seen the advice for this problem on earlier versions and have tried removing SSMS 2022 and reinstalling SSMS 2019 (version 15.0.18424.0) and I've run a repair on SQL toolbelt, but it doesn't appear to make a difference.
Should I remove Toolbelt essentials and reinstall from scratch? Or is there a better fix available?
Thanks in anticipation.
JohnHyde
1 ·
Re: Device ID in SQL Backup Pro
Hi @HVo
To find the device ID you will need to go to:
C:\ProgramData\Red Gate\Licenses
There you should see a SQL Backup license file. Open that file and you'll see the Machine hash which corresponds to the entries in the portal under the usage tab.
To find the device ID you will need to go to:
C:\ProgramData\Red Gate\Licenses
There you should see a SQL Backup license file. Open that file and you'll see the Machine hash which corresponds to the entries in the portal under the usage tab.
Kurt_M
1 ·