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

ysjxjf 2003-04-09 09:33:21
我在執行下面的語句時﹕
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
...全文
29 点赞 收藏 3
写回复
3 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
ysjxjf 2003-04-09
我的表中在主鍵上有重的﹐ 即可.


多謝各位!!!
回复
mjhnet 2003-04-09
GZ
回复
leimin 2003-04-09
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
回复
相关推荐
发帖
疑难问题
创建于2007-09-28

2.1w+

社区成员

MS-SQL Server 疑难问题
申请成为版主
帖子事件
创建了帖子
2003-04-09 09:33
社区公告
暂无公告