Activity overview
Latest activity by Vic
Yes, SQL Prompt 11 is now available in SSMS 21 GA - it won't work in the preview versions. You can copy these settings manually from v10 folder to v11 folder by following below steps. Copy contents of C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\CodeAnalysis to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\CodeAnalysis Copy contents of C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ Snippets to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\ Snippets Copy contents of C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ Styles to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\ Styles Copy ConnectionColoringCategories.xml , ConnectionColoringServers.xml , RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml , RedGate_SqlPrompt_Engine_EngineOptions.xml files from C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 10\ to C:\Users\{USER}\AppData\Local\Red Gate\SQL Prompt 11\ / comments
Yes, SQL Prompt 11 is now available in SSMS 21 GA - it won't work in the preview versions.You can copy these settings manually from v10 folder to v11 folder by following below steps.Copy contents o...
Hi friedrich.eberharter I've just checked the SQL Search requirements and I'm afraid it doesn't support SSMS versions 18.0 - 18.4: https://documentation.red-gate.com/ss/requirements / comments
Hi friedrich.eberharter I've just checked the SQL Search requirements and I'm afraid it doesn't support SSMS versions 18.0 - 18.4:https://documentation.red-gate.com/ss/requirements
Support for SSMS 21 GA with SQL Prompt should be available with the next release of SQL Prompt. Once this new version is out the release notes will also be updated here: https://documentation.red-gate.com/sp/release-notes-and-other-versions / comments
Support for SSMS 21 GA with SQL Prompt should be available with the next release of SQL Prompt. Once this new version is out the release notes will also be updated here:https://documentation.red-ga...
Hi friedrich.eberharter Are you able to provide the SQL Search log files so that we can see what's happening? https://documentation.red-gate.com/ss/troubleshooting/logging-and-log-files If you don't want to attach them to this post, please send them to support@red-gate.com referencing ticket no. 333034. / comments
Official comment
Hi friedrich.eberharter Are you able to provide the SQL Search log files so that we can see what's happening?https://documentation.red-gate.com/ss/troubleshooting/logging-and-log-filesIf you don't ...
Add SQL History to a shared folder
Following these steps will enable you to relocate the SQL History file to a shared folder.
1. Open regedit2. Go to Computer\HKEY_CURRENT_USER\Software\Red Gate\SQL Prompt 10\3. Add a string value w...
Hi Dredger Yes, SQL Clone and SQL Data Masker both support SQL 2022. / comments
Official comment
Hi DredgerYes, SQL Clone and SQL Data Masker both support SQL 2022.
Hi all Please can you try uninstalling SSMS 21 and SQL Prompt and then reinstall, SSMS first and then SQL Prompt, to see if that fixes the issue. https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.16.11.16409.exe / comments
Hi allPlease can you try uninstalling SSMS 21 and SQL Prompt and then reinstall, SSMS first and then SQL Prompt, to see if that fixes the issue.https://download.red-gate.com/checkforupdates/SQLProm...
Hi Rasmus @... How are you installing SQL Prompt; are you installing on both SSMS and VS or just SSMS? Are you installing the software or is an admin installing it for you (is the installer being run as a different user to the one running SSMS?) Does SQL Prompt appear in other versions of SSMS that you have installed? / comments
Hi Rasmus @... How are you installing SQL Prompt; are you installing on both SSMS and VS or just SSMS? Are you installing the software or is an admin installing it for you (is the installer being r...
Hi Rasmus SQL Prompt added preview support for SSMS 21 as of version v10.16.6. It's possible to patch into a current version of Prompt and add it into SSMS 21 for usage. The latest version V10.16.8 can be accessed here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.16.11.16409.exe It may be necessary to make some changes to settings in SSMS 21 to enable the Redgate extensions, please refer to this guide and the section Running SQL Prompt with SSMS 21 Preview: https://documentation.red-gate.com/sp/getting-started/installing-and-running-sql-prompt The main setting to check is that both SQL Prompt extensions are disabled in the Extensions > Customize Menu... menu selection. [image] [image] / comments
Official comment
Hi Rasmus SQL Prompt added preview support for SSMS 21 as of version v10.16.6. It's possible to patch into a current version of Prompt and add it into SSMS 21 for usage. The latest version V10.16.8...
This may be a legitimate duplication and case-comparison is off; or the view is being created twice somehow in the scripts folder. First check I would recommend is in the Project settings > Options > Use case-sensitive object definition. If that is disabled, enable it. If you have a program to search for text within files (I use Agent Ransack personally, but there are others) search for that view [vw_RGTest] to see if it exists in multiple CREATE statements. Otherwise, if you are using a filter in your Compare project - it may be possible that you are excluding dependencies that are causing SQL Compare to treat this object as new and then creating this duplicate definition error. / comments
Official comment
This may be a legitimate duplication and case-comparison is off; or the view is being created twice somehow in the scripts folder. First check I would recommend is in the Project settings > Options...