can not truncate sql table, nor drop the index of a tab
Posted on 2011-03-15
I have a table in the SQL data base, current have just over 1 million rows.
1. I need to create a new index, but it runs and run forever., I have to abort it.
2. but I can use bcp utility to dump all the rows to a text file.
3. I I can also use ado recordset to insert new row to the table
4. I can do everything with the table, other than I can not truncate table (I intend to create the index after I truncate it. then use bcp to reload the data.
can someone help?