Activity overview
Latest activity by ccage90
How should I change the cache management settings? Always run with refresh checkbox disabled? I'll try it.
I have a snapshot of a lockup that just happened to me. The SQL prompt popup read "Indexing database objects..." and the query analyzer window title bar indicated that the program was "(Not Responding)".
Thanks,
Chris
[/url] / comments
How should I change the cache management settings? Always run with refresh checkbox disabled? I'll try it.
I have a snapshot of a lockup that just happened to me. The SQL prompt popup read "Indexin...
Bart,
Sorry for the delay. I will try to get a screenshot for you next time.
I believe the progress bar popup usually indicates that it is reading objects or indexing. I also noticed last time that the query analyzer window title bar shows "Not Responding" when I click in that window.
I still have not determined how to reproduce this regularly. It seems to happen every few days after my computer has been running for a while without reboot.
Thanks,
Chris / comments
Bart,
Sorry for the delay. I will try to get a screenshot for you next time.
I believe the progress bar popup usually indicates that it is reading objects or indexing. I also noticed last time that...
Bart,
Thanks for responding. I am working on a laptop and use it at the office and over VPN while offsite. I typically switch between networks before rebooting. In other words, I work at office with QA open, put computer to standby and undock, open computer at home, connect to VPN, and use use same QA instance over VPN.
However, at the time I have the stalls from SQL Prompt, I have connectivity to all db servers. I'll open a new QA connection and see the popup in the corner, it gets to 30-40% progress during which time it seems SQL Prompt is in background thread. That is, I can still work in the QA window. Then, suddenly SQL Prompt takes over and I can't click/type in the QA window for up to several minutes. I then try finding ctrl-C or other cancel options to no avail.
One other item to report: I often open more than one instance of query analyzer, one for each server connection. (This is when I get the multiple SQL Prompt menus within the first QA instance. Harmless feature...) I find pretty regular crash-bug of Query Analyzer when starting the second instance since installing SQL Prompt 3. Then trying again, I am able to open second QA.
Thanks.
Chris / comments
Bart,
Thanks for responding. I am working on a laptop and use it at the office and over VPN while offsite. I typically switch between networks before rebooting. In other words, I work at office wit...
I experience this bug regularly also.
Chris / comments
I experience this bug regularly also.
Chris
I wanted to report the same experience with SQL Server 2000 Query Analyzer. It is very frustrating. The free version SQL Prompt was less intrusive than this. I might have to switch back until these bugs are fixed.
Chris / comments
I wanted to report the same experience with SQL Server 2000 Query Analyzer. It is very frustrating. The free version SQL Prompt was less intrusive than this. I might have to switch back until these...