Texis indexes

Post Reply
skalyanaraman
Posts: 109
Joined: Tue May 29, 2001 9:13 pm

Texis indexes

Post by skalyanaraman »

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!!
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Texis indexes

Post by John »

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.
John Turnbull
Thunderstone Software
Post Reply