高手過來看看----有關 delete 的錯誤 在線

[ysjxjf]

我在執行下面的語句時﹕
delete lk_attend_data where attend_date between '2003.03.01' and '2003.03.31'

共有 86220 條記錄. 并且在檢索時沒問題.

出現如下錯誤:
Server: Msg 624, Level 20, State 2, Line 1
Could not retrieve row from page by RID because the requested RID has a higher number than the last RID on the page. Rid pageid is (1:2827) and row num is 0x12.Page pointer = 0x55606000, PageId = (1:2827), flags = 0x8, objectid = 1233439468, indexid = 0, DBID 9.

Connection Broken

[leimin]

first you run:
DBCC DBREINDEX
DBCC INDEXDEFRAG

AND then

run
delete lk_attend_data where attend_date between '2003.03.01' and '2003.03.31'


delete again

[mjhnet]

GZ

[ysjxjf]

我的表中在主鍵上有重的﹐ 即可.


多謝各位!!!