Activity overview
Latest activity by Ben Patel
Thank you for your post. I've replicated the same behaviour locally and can see the examples in the Microsoft docs, so I'll pass this on to the developers for a fix. / comments
Official comment
Thank you for your post. I've replicated the same behaviour locally and can see the examples in the Microsoft docs, so I'll pass this on to the developers for a fix.
Hi rvernals on the machine where you transferred the the SQL History to, can you navigate to %localappdata%\Red Gate\SQL Prompt 11\SqlHistoryIndex and delete the contents of that folder. Then open SSMS and try searching SQL History again. Are the expected results now found? / comments
Hi rvernals on the machine where you transferred the the SQL History to, can you navigate to %localappdata%\Red Gate\SQL Prompt 11\SqlHistoryIndex and delete the contents of that folder. Then open ...
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...