Texis indexes

skalyanaraman · Post by **skalyanaraman** » Tue Aug 07, 2001 6:14 pm

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!!

Post by **John** » Tue Aug 07, 2001 8:10 pm

In SYSINDEX is the type of the index 'D'? That indicates that not all the files could be removed as they were still in use, and NT does not allow the removal of files that are in use. The entry is maintained in SYSINDEX so those files will be removed when that is possible.