Hello Greg,

Forgot to mention this, as I told you before the data transfer can be between any two tables, so there are quite good number of tables in my database,...

Hello Gregory,

I have no idea about Fill Factor. But I cann't do an delete and insert as there may be some records that I would not be updating from the...

Hello All,

After a week's struggle we were able to figure out the problem that was making my MMC and SQL Query Analyzer to fail.

A particular machine on our network was...

Brian,

I have a dot net machine, with out these two apps, but I still got the error on this machine. However I have a winXP with .net which didn't have...

Brian,

The box without .net is my test machine it has nothing else on it except SQL 2000, PC Anywhere and Cisco VPN Client.

Yes Brian,

I am getting the same error again. I have reinstalled the client tools and also the sp2, but still got the same problem. Brian, do you think that a...

Kelly,

I do not see any other similarities. The latest test I performed, I checked for any kind of errors before installing MDAC 2.7 Refresh, and I could not find any....

Here is one more thing I found out. when I

installed MDAC2.7 Refresh. on an win 2000 machine with SQL 2000 and when

I try to do a look up for servers...

As of on the four machines that I have installed this problem only showed up after I installed dot net on these machines, so that was my only guess that...

Hello bkelley, katravax

Thanks for your immediate response,

Kelly I had SQL installed before dot net. I had the same problem on 4 systems, but I could not see this problem with...