Activity overview
Latest activity by Ben Patel
Announcement for SQL Prompt - SQL Prompt 11 is now out and supports SSMS 21 GA
SQL Prompt 11 is now available:https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-11-0-release-notes
11.0.0.16715 - Released on 28th May 2025
Features
Added support ...
Hi All, Thank you for your patience, and apologies for how long this fix has taken to come out. With the release of SQL Prompt 10.16.11, the issue with Azure MI and MFA is now fixed, and you should once again be able to connect to this instance type and get suggestions: Link to the release notes: https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-16-release-notes Latest available version: 10.16.11.16409 / comments
Official comment
Hi All,Thank you for your patience, and apologies for how long this fix has taken to come out.With the release of SQL Prompt 10.16.11, the issue with Azure MI and MFA is now fixed, and you should o...
Hi Curtis, This issue was fixed in a later version of SQL Prompt (10.16.7) Could I ask you to try updating to the latest version and see if that resolves the issue: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.16.10.16350.exe The release notes can be viewed here: https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-16-release-notes / comments
Official comment
Hi Curtis,This issue was fixed in a later version of SQL Prompt (10.16.7) Could I ask you to try updating to the latest version and see if that resolves the issue:https://download.red-gate.com/chec...
I've tried to replicate this, but I don't seem to be getting the same outcome. After both uninstalling and reinstalling a newer version and then directly updating to a newer version the custom menu is still there for me. So perhaps an issue with SSMS 20. / comments
Official comment
I've tried to replicate this, but I don't seem to be getting the same outcome. After both uninstalling and reinstalling a newer version and then directly updating to a newer version the custom menu...
Hi Simon, to search the literal string enclose the search term in double quotations. / comments
Official comment
Hi Simon, to search the literal string enclose the search term in double quotations.
Hi Kalo, Do you mean the SQLHistory DB? If so then I'm not sure as we don't support directly querying the DB. Also as an added thing, if you run into this issue again, you can try deleting the indexing data for the SQLHistory.DB in %localappdata%\Red Gate\SQL Prompt 10\SqlHistoryIndex folder, then when you re-open SSMS this will be rebuilt. / comments
Official comment
Hi Kalo,Do you mean the SQLHistory DB? If so then I'm not sure as we don't support directly querying the DB. Also as an added thing, if you run into this issue again, you can try deleting the index...
I've heard back from the developers now, and they have a fix for this issue scheduled in the next release of SQL Prompt. The release notes for this will be posted here when available: https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-16-release-notes / comments
I've heard back from the developers now, and they have a fix for this issue scheduled in the next release of SQL Prompt. The release notes for this will be posted here when available:https://docume...
Hi George, Which version of SQL Search are you running? The latest currently is 3.7.2.5316. If you could also confirm the version of SSMS that you are running. Assuming you are on the latest version and running SSMS 19 or 20, could you close SSMS, then try navigating to %localappdata%\Red Gate\RedGate.SQLSearch.Addin 3\Indexes, then delete the indexes for each DB. Next open SSMS and open a SQL Search window and go to Index>Re-index,. Then allow a few minutes for this to finish and then try to search your DB objects. / comments
Hi George,Which version of SQL Search are you running? The latest currently is 3.7.2.5316. If you could also confirm the version of SSMS that you are running. Assuming you are on the latest version...
It looks like there is an issue with the search when listing the object type as “Queries”. Rather than showing only queries, it's highlighting the word as well when ever it appears, which I don't believe it should be doing, so I'll double-check with the developers to see if it's expected and if not then ask it this can be fixed. / comments
It looks like there is an issue with the search when listing the object type as “Queries”. Rather than showing only queries, it's highlighting the word as well when ever it appears, which I don't b...
Hi there, thank you for your post. Are you able to check what options you have set for the “Advanced Search” options? Is it set to search on everything or queries only? / comments
Official comment
Hi there, thank you for your post.Are you able to check what options you have set for the “Advanced Search” options? Is it set to search on everything or queries only?