We are running on an NT4.0 sp6 server with nt40 and win2000 workstations.

There are probably no more than 6 people in the table at one time.

The application is built on Visual Promatrix. The referential integrity is not working, the queries are slow and the relate to a GIS coverage doesn't work any more as well as reindex command not working.

The indexes for the table is

stand township+range+section+stand
ostand township+range+section+ostand
compartno PADL(ALLTRIM(STR(compartno)),2,"0")+township+range+section+stand
deleted DELETED()
record_no "A"
birthyr STR(birthyr)+covertype+fsilv

The other tables all have similar indexes. The indexes are non structural .cdx's