One possible way which works on XP (I don't have 2003 around to play with yet).  And it won't work from explorer, but it can be done from a command...

Dang...just lost my whole post.

Anyway what I wanted to say is that NIC errors usually won't show up in the event log unless the connection drops entirely.  If you have...

It could well be a network bottleneck especially if the behavior is inconsistent as you stated.  Are there other instances of SQL Server that you connect to and if so,...

Allen is correct.  You don't have a lot of options with only 3 drives.  How large are your databases? 

If I were building this, I'd go ahead and buy an...

Make that Deja Vu with an advancing case of Alzheimer's disease...

I checked and the previous question from 7/20 was:

"Most of us know that SQL Server listens on port 1433 for...

Glad to see I'm not the only one.  That was like Deja vu...all over again.  I'll take the points though 

Microsoft has a procedure described here that I've used for this before when moving databases that works well:  http://support.microsoft.com/default.aspx?scid=kb;en-us;298897&Product=sql

Hope this helps.

And BTW...I sincerely apologize for the way I opened my first post.  I fully recognize that there are a lot of great resources of both sexes out there and if...

JFW - That worked perfectly.  Query now returns results in 3 seconds.  This for me was a perfect case of not seeing the forest for the trees.  If you're ever...

Interesting.  I always assumed it used DNS but can't find any documentation to support that.  Do these connections come back after you restart the server?  Does pinging the host from...

Do you mean the entries showing from the drop down when registering a new server?  If you are seeing old entries here, you may have old or outdated Aliases set...

Interesting.  We use Legato for several applications and I haven't heard about this.  But my Network Admin who was our resident Legato expert recently left the company to start his own...

I have to agree with Steven that the component checker is the best way to verify and troubleshoot clients.  Different installs of various products can alter MDAC installations and this...

One thing...8.00.194 is the original release version.  Are you sure the SP3 applied properly?  SP3 versions shoud be at 8.00.760 or higher.  Make sure that your account has administrative rights...

Almost forgot...

Something else to check is to make sure the source database is not in Read-only mode as this will generate an error and cause the copy to fail.  Check 'Using...