Has anything been found to fix this problem????

Thanks,

Dan

I did a search on the internet and supposedly there is a fix for Query Analyzer NOT RESPONDING issues. Do you know of this and if so where can I...

SP_WHO

1 0 background                     sa                                                                                                                                  0     NULL LAZY WRITER    

2 0 sleeping                       sa                                                                                                                                  0     NULL LOG WRITER     

3 0 background                     sa                                                                                                                                  0     master SIGNAL HANDLER 

4 0 background                     sa                                                                                                                                  0     NULL LOCK MONITOR   

5 0 background                     sa                                                                                                                                  0     master TASK MANAGER   

6 0 background                     sa                                                                                                                                  0     master TASK MANAGER   ...

The databases are not auto closing.

The OBDC is fine, no logging. The servers have 1 gig of memory. No large table to eat up memory. The SQL servers min. memory is 512 and 1024 max....

Just to give you some more information. I get the same thing when accessing EM or Query Manager on the server itself. This may not be a network issue.

Dan

I have updated the NIC card drivers and it did not change a thing. Where is the authentication for SQL Server 2000??

Dan

This is occurring on 2 servers. I do not have them clustered. I use both Query Analyzer and Enterprise Manager and it works the same for both. It occurs when...