Hi,
We are having a database in NT. Let us say F:\database\c3casered\tbldoc. There is a table called tbldoc and has indexes in it. When I try to drop the indexes, by running,
tsql "drop index idxmtbldoc_DOCID".
The statement runs fine but the index is still in SYSINDEX. I dont get any error.
Also, among the six files that are there for a typical index we have only two, the _T and the _D files.
I can try and run the drop index many more times and dont get any error at all, the index does not get dropped.
Any ideas?? Thanks!!
We are having a database in NT. Let us say F:\database\c3casered\tbldoc. There is a table called tbldoc and has indexes in it. When I try to drop the indexes, by running,
tsql "drop index idxmtbldoc_DOCID".
The statement runs fine but the index is still in SYSINDEX. I dont get any error.
Also, among the six files that are there for a typical index we have only two, the _T and the _D files.
I can try and run the drop index many more times and dont get any error at all, the index does not get dropped.
Any ideas?? Thanks!!