Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Query Analyzer Hangs

Author  Topic 

memarcie
Yak Posting Veteran

91 Posts

Posted - 2007-11-02 : 10:32:00
I have a problem when I open a saved query using query analyzer and modify it. When I resave the query, my query analyzer stops responding and I have to end it. Has anyone encountered this issue and know of a fix?

Thanks,
Marcie

Kristen
Test

22859 Posts

Posted - 2007-11-02 : 11:58:31
Mine crashes occasionally - usually when I load a script whilst another is running, but it can be when I do something when QA is busy in some other way.

As best as I can judge it I am 99%+ sure it is related to name resolution within our network, and something on my PC that gets into a go-slow-loop trying to resolve something on the network - perhaps an IP address that is duplicated on something like that.

Can't put my finger on it any more than that though ...

Kristen
Go to Top of Page

memarcie
Yak Posting Veteran

91 Posts

Posted - 2007-11-02 : 12:16:37
I found this comment about the issue but this is related to nvidia. I don't have this on my pc. It happens every time I open a query and try to save it.

http://www.webservertalk.com/message91261.html
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-11-02 : 12:46:34
" I don't have this on my pc"

me neither ...

"It happens every time I open a query and try to save it"

That is more sever than here, unless you have name resolution issues on wherever you are trying to save to (or something that checks files when they "land" in that folder, or somesuch)

I thought this might be interesting from your link:

quote:
When QA hangs, what, if any, processes are consuming CPU time,
according to Windows Task Manager? Perhaps a virus checker or other
security?


Kristen
Go to Top of Page
   

- Advertisement -