Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SSCE losing indexes
3 views
Skip to first unread message
Robert Greenfield
Aug 16, 2010, 1:29:57 PM8/16/10
to
I'm having an issue where indexes and primary keys are disappearing
from tables in a SQLCE 3.0 database. There is nowhere in the program
where I'm explicitly dropping indexes. All data transactions are via
a common connection either through a command object or a resultset. I
don't know whether the indexes are disapearing during database
transactions or when the repair method is executed. Is there any
known issue of ssce databases losing indexes? Is there anything I
should be doing to keep these from disappearing? My only alternative
at this point is to check and recreate the indexes when the program
opens.
from tables in a SQLCE 3.0 database. There is nowhere in the program
where I'm explicitly dropping indexes. All data transactions are via
a common connection either through a command object or a resultset. I
don't know whether the indexes are disapearing during database
transactions or when the repair method is executed. Is there any
known issue of ssce databases losing indexes? Is there anything I
should be doing to keep these from disappearing? My only alternative
at this point is to check and recreate the indexes when the program
opens.
0 new messages