How can we help you today? How can we help you today?
Calen
Activity overview Badges (0) Posts (2) Comments (3)

Activity overview

Latest activity by Calen

Hi Bart, Thanks for a quick reply. When SQL Prompt is hung up, the CPU is mostly idle. SqlWb.exe will have from 0 to 5% and Mem Usage of around 820,000 KB. This happens even with Cache Management set to NOT automatically update. It doesn't seem to care about that setting. Another very annoying, but not as serious, aspect of all this... the semi-transparent window that says that SQL Prompt is indexing or loading in the lower right hand corner of the screen. It's there no matter what application window I bring up. This can be actually interfere with my being able to work on something else while SQL Prompt finishes doing whatever it thinks it's supposed to be doing. I'm using a dual core 2.8 GHz Pentium 4 Dell machine with 2 GB of RAM, running Windows XP Pro (SP2). Is there any way to stop SQL Prompt from doing that indexing and such, every single time I open a query? (Other than Task Manager, of course.) Thanks, Calen / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Why does SQL Prompt slow down SQL 2005 Management Studio?
Hi Bart, Thanks for a quick reply. When SQL Prompt is hung up, the CPU is mostly idle. SqlWb.exe will have from 0 to 5% and Mem Usage of around 820,000 KB. This happens even with Cache Management ...
0 votes
Over 4 months since I started this thread, and I see that no solutions have been put forward for this problem. Is Red Gate even working on it, or have we been hung out to dry? I have spent 2 hours this morning staring at the SQL Prompt window in the lower right hand corner of the screen saying either "Loading snapshot file..." or "Indexing database objects...". And I'm only trying to open a New Query on the database that I've been working on, and for which the cahce was already refreshed. But, with several departments waiting on me to run some ad hoc reports, I can't get SQL Server Management Studio to work due to SQL Prompt freezing it up. Refreshing the cache manually doesn't stop this, either. It still hangs up while loading, or indexing. How about a real solution to this VERY FRUSTRATING PROBLEM?!?!?!? Not just a "not saying this will help ... and this may actually worsen the situation..." (From Mar 07) On Feb 22, Bart said "...if it's what I think it is then I fixed it earlier today..." Would you mind posting that fix? If I "walk away" for 15-30 minutes it might (or might not) come back from the freeze. Could some method be added to SQL Prompt to allow the user to interupt whatever it's doing that it's freezing up on. Reading the history of this thread, it really seems like this very serious problem was just dropped. Can it be picked up again? Is anyone working on this? Will Red Gate refund our money for slowing us down, instead of speeding us up? To try to be fair. When SQL Prompt works, it is great. I really don't want to stop using it. But, when it doesn't, it prevents me from doing any work at all. Unless a solution is forthcoming, I am just about ready to uninstall all Red Gate products, demand refunds, and disrecommend it to PASS (Professional Assoc. for SQL Server) and everyone I meet. (By the way, I've been waiting for the Cache Management window to come up while I've written this. Over 15 minutes and it is only a blank while window with no contents.) At my wits end, Calen / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Why does SQL Prompt slow down SQL 2005 Management Studio?
Over 4 months since I started this thread, and I see that no solutions have been put forward for this problem. Is Red Gate even working on it, or have we been hung out to dry? I have spent 2 hours...
0 votes
As a follow up to my earlier post... I've now been waiting for over 15 minutes for SQL Prompt 3 to let go of SQL Server 2005 Management Studio. There is a SQL Prompt popup in the lower right hand corner that says "Loading from snapshot file", but it is a database that I'm not working with. While that's happening, SSMS is blank, just a white filled window with a title bar. Evaluating SQL Prompt 3 is now preventing me from being able to do any of my work!!! Please reply with a solution to this problem. Is there something that I did wrong when I installed it? Is there a setting that needs to be set/unset? Other than drastic measure like Task Manager, is there any way to make SQL Prompt let go of SSMS? Why does it have to do this in the foreground anyway? This is beyond frustrating. It is becoming infuriating. Please help make SQL Prompt work as advertised, or I'll have to demand a refund of the order my boss just placed. Thank you, Calen / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Why does SQL Prompt slow down SQL 2005 Management Studio?
As a follow up to my earlier post... I've now been waiting for over 15 minutes for SQL Prompt 3 to let go of SQL Server 2005 Management Studio. There is a SQL Prompt popup in the lower right hand ...
0 votes
Why does SQL Prompt slow down SQL 2005 Management Studio?
  1. Community
  2. SQL Prompt Previous Versions
When I am connecting to network databases, SQL Prompt 3 will often make SQL 2005 Management Studio come to a complete halt for 5, 10, even 15 minutes at a time. Sometimes a semi-transparent window...
9 followers 25 comments 0 votes
Error Trying to Connect to Local DB
  1. Community
  2. SQL Prompt Previous Versions
Hi, I'm using SQL Server 2005 Management Studio and when I try to connect to a database on my computer, it tries for about 15 minutes, then throws this error: See the end of this message for detail...
1 follower 4 comments 0 votes
Total activity
6
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1