Activity overview
Latest activity by csuire
MatthiasMcRobbin said:
I experienced the same issue with SQL Search 3.5.3 after upgrading from an earlier version of SSMS to 18.9.1. To resolve, I uninstalled SQL Search, deleted the "C:\Program Files (x86)\Red Gate" folder and installed SQL Search again.
Thank you! I struggled with this issue this week with SSMS 2019.1 and SQL Search 3.6.7.3908 Multiple reinstalls did not work. But finally found your comment and deleted the left over files after another uninstall and that did fix the issue. Posted here mentioning this issue/fix too https://forum.red-gate.com/discussion/89626/sql-search-now-available-for-ssms-19? / comments
MatthiasMcRobbin said:
I experienced the same issue with SQL Search 3.5.3 after upgrading from an earlier version of SSMS to 18.9.1.To resolve, I uninstalled SQL Search, deleted the "C:\Progr...
I tried this issue again and was able to reproduce. It doesn't happen every time. Used version 1.4.16.1316 I could reproduce with 8 databases and 3 threads. Shows 7 results. I could reproduce with 3 databases and serial execution. Shows 2 results. It is inconsistent. Sometimes it will show all the results and sometimes it's missing one or more results.
Steps to reproduce: 1. Load 3 databases. Set options to use serial execution. 2. Run the query below and immediately switch to the "Results" tab to watch the results come in. 3. When footer showed "Script executed successfully on 3 databases", the results only had 2 rows. 4. Switching between Messages and Results tabs redraws the results and then all 3 database results are visible. Example Query used to give enough delay to click on Results tab before all results are shown: WAITFOR DELAY '00:00:05' --Big enough number to allow you to click script and switch to Results SELECT 'test' I tried this on two computers and was able to reproduce the issue on both. [image]
/ comments
I tried this issue again and was able to reproduce. It doesn't happen every time.Used version 1.4.16.1316I could reproduce with 8 databases and 3 threads. Shows 7 results.I could reproduce with 3...
Feature Request: Results error filtering and feedback
I would like some sort of results filter to see just the databases and/or messages that errors.Also show a count of databases that have errored near the progress.script1.sql (233 of 1114) [1 with e...
This would help me to automatically add new cloned databases to my distribution list. Each time I use this program I have to go through these steps to add new cloned databases before running scripts. Configure->Expand Server->Highlight all dbs that start with a certain word->Add. / comments
This would help me to automatically add new cloned databases to my distribution list. Each time I use this program I have to go through these steps to add new cloned databases before running scrip...
1.3.4.886 still has this problem.
I almost missed gathering some data the other day before I remember to use my workaround to refresh the results tab. Simple steps to reproduce:
1. Load 4 databases. Set options to use parallel execution against 2 databases at a time.
2. Run the query below and immediately switch to the "Results" tab to watch the results come in.
3. When footer showed "Script executed successfully on 4 databases", the results only had 3 rows.
4. Switching between Messages and Results tabs redraws the results and then all 4 database results are visible. Various combinations
Using 2 threads, I reproduced this with even number of databases (4, 6, and 8 databases). Each time is was missing 1 row of results.
Using 2 threads, I could NOT reproduce this with odd number of databases (3,5, and 7 databases).
Using 3 threads, with 7 databases, it would drop 2 rows of results until refreshed.
Using 3 threads, with 8 databases, it would drop 1 row of results until refreshed. QUERY:
WAITFOR DELAY '00:00:05'
SELECT 'test' / comments
1.3.4.886 still has this problem.
I almost missed gathering some data the other day before I remember to use my workaround to refresh the results tab.Simple steps to reproduce:
1. Load 4 databases....
Thanks Eddie. I submitted the information by email as requested.
For anyone else following this issue, to reproduce this problem, you must select the results grid as soon as possible and before all of the databases are processed. If you wait until after all of the databases are processed, then you will be selecting the results grid and forcing a draw of the results. The problem is that when watching the results stream in, the program doesn’t always draw all of the results into the grid. But a forced redraw by for example clicking Messages and then Results does fix the issue.
I currently have about 1000 databases and am using 25 threads. This takes 9 seconds. That is enough time to switch to results grid under normal usage before all of the results are available.
But I just reproduced this problem with 36 databases and 25 threads, by adding a WAITFOR DELAY to the query to give me time to switch to results and watch them stream in.
I tried reproducing this issue with 5 databases and 2 threads, but wasn’t able to with a couple of attempts.
Here is the query I used for the 36 database 25 thread test that did reproduce the issue:
WAITFOR DELAY '00:00:03'
SELECT 'test' / comments
Thanks Eddie. I submitted the information by email as requested.
For anyone else following this issue, to reproduce this problem, you must select the results grid as soon as possible and before al...
2017-04-20 Bug v1.3.2.883 - Not displaying some database results when done until toggling UI
I'm running a query against a lot of databases and sometimes the UI results grid does not show all of the results when completed until I toggle between UI elements such as Messages/Results tabs, or...
1.2.5.477 Bug: "On Error" dropdown is not saved
When upgrading from 1.1 to 1.2 the "On Error" dropdown stopped remembering its previous value.
I want to leave it at "Continue executing" each time the program starts.
You fixed the issue in 1.2 wh...