Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2012-02-14 : 13:44:54
|
| I have a table with primary key having an indexI rebuild the index while the system was on line beforeI am inserting a record I can see the record but on displaying top 10 desc I can not see it.The table also is linked to other tables shall I shut down the system and rebuild all the indexes for all the tables or how to fix that.How to find where the corruption is thankssarah |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sarahmfr
Posting Yak Master
214 Posts |
Posted - 2012-02-14 : 17:29:58
|
| This is not coding error because after rebuilding the index i can see the last recordmy query is select top 1 * from xxxxorder by messageid descthankssarah |
 |
|
|
|
|
|
data corruption