What is the best way to determine if a table has a corrupted index?
Can this be determined without doing a seek?
I am performing a replication of data from one database to another database remotely. I am not using remote views, but going directly against the tables at the remote site via the web. Due to any number of reasons, the tables are getting corrupted. Thus the next time replication occurs, the update fails.
Would using remote views be wiser?
Short of going to SQL, is there anything that I can do to reduce the occurrence of this index corruption?
BTW, one of the tables is getting quite large, 800,000 records with indexes.
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only