Hi

I am running sql 6.5 sp5 on NT 4.0 sp6. I have a table with 70+ mil rows and I ususally use bcp to add data to it. I usually have to remove the index on my table to run the bcp command. I tried bcp data into this table with my index and I had waited over 48 hours and I did not see any progress. Now my problem is that I cannot remove my index. SQL Server does not return any error message to me but view the index form SQL Enterprise Manager, I see the index is still there.

Please comment. Thanks

Betty Lee