We're running SP4, build 2039. Could that be a problem?

Also, to answer an earlier question: The server is running Windows Server 2003 R2, Standard x64 Edition, Service Pack 1....

Oops. I just saw your offer for the Kbase # for that buffer overrun error. Sorry, my bad. Yes, that Kbase # would be very helpful.

John,

I've not been able to get SQLDiag to actually run. All I get, after it processes the logs, while it's "Getting registry information" is this error:

"Buffer overrun detected."

I've searched...

I'm not familiar with SQLDiag. Is that an executable, a SPROC, something I need to download? It sounds like it would be a great tool.

Thanks Jeff!

I had checked the auto-shrink wondering if that was it -- it wasn't -- but, you're right, the autogrowth is turned on and the file is big and it...

Alzdba, THANKS SO MUCH FOR THE SCRIPT!

I'm going to give it a try tomorrow during the times when the freeze sometimes occurs and I'll let you know what I find.

And,...

Alzdba, thanks for the input. There are no backups or rebuilds going. SQLProfiler doesn't seem to report anything (though I'm not sure what I should be tracing), and...

The NIC card idea is a good one because there are other weird problems going on with this server (for example, My Network Places can't see any of the other...

I, at one time, thought that the problem might could be solved in the network settings -- they both had the same named pipe. So, in my changes I...

No, they're not linked in any way, no triggers at all, and no replication is set up. These servers are completely independent. The "second" has been running for...