Activity overview
Latest activity by Ben Patel
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
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?
Redgate Monitor - What does "License will expire in 'X' days. You need to buy or allocate licenses to Redgate Monitor installation" mean?
The message refers to the file that is placed on you machine when you have activated a license. You will need to re-apply the license using the new activation in order to fully refresh the permit.
...
Redgate Monitor has reverted to a trial after upgrading to version 12
When upgrading from any major version prior to version 12 (e.g. upgrading from 10-12) you'll find that your licenses have deactivated and are no longer visible on the licensing page. This behavior ...
Redgate Monitor Base Monitor Service Account
For ease of use, Redgate recommends running the Redgate Monitor Base Monitor Service using a domain service account with adequate permissions as specified here. We recommended using this account to...
Redgate Monitor offline activation
This article shows you how to activate and deactivate your Redgate Monitor license offline when you don't have a connection to the Redgate Licensing Client.
Go to the Licensing page in Redgate Mo...
Upgrading Redgate Monitor
Preparing to upgrade
Open Redgate Monitor web interface, go to Configuration > About and make a note/copy of the existing web server and base monitor details, including the location of the Red...