為什麼執行一個簡單的關聯查詢語句都會出錯?

[sunylf]

錯誤如下：
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

(6471 row(s) affected)

數據庫為:ms Sql Server 2000 Sp4
查詢語句如下:
select * FROM vwSOrderZb Z,vwSOrderMx M WHERE Z.SOrderNo=M.SOrderNo
單獨執行 select * from vwSOrderMx
select * from vwSOrderZb是沒有問題的。

請高手盡快給予指點!甚謝!!!

[sunylf]

DBCC CHECKDB ( 'SemiJason')
出現如下錯誤:

Server: Msg 2537, Level 16, State 40, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:1545), row 58. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:1545), row 77. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:1545), row 88. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:1545), row 89. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:1545), row 103. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:1546), row 93. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:1546), row 102. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:1547), row 20. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:2342), row 49. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:2342), row 61. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:2343), row 2. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:4051), row 95. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:4051), row 96. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:5600), row 58. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
Server: Msg 2537, Level 16, State 1, Line 1
Table error: Object ID 1189579276, index ID 2, page (1:5600), row 69. Record check (length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 43 and 40.
DBCC results for 'SemiJason'.
DBCC results for 'sysobjects'.

CHECKDB found 0 allocation errors and 15 consistency errors in database 'SemiJason'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (SemiJason ).

[sunylf]

修復錯誤後還是會出現前面的錯誤!

[灰太狼]

fatal exception 呀，应该不是语句的问题，lz看看sql server安装是否正确吧

[sunylf]

發現一個問題就是第一次執行出錯後，馬上接著再執行一次後就正常了，過一段時間後再次執行又出現同樣錯誤。
不知是不是電腦不夠快的原因，緩沖不過來。

[忆轩辕]

汗，库出问题了。。。。。。。

先备份数据库

然后先用dbcc checkdb('SemiJason',REPAIR_REBUILD)

如果还是有错误的话就用
dbcc checkdb('SemiJason',REPAIR_ALLOW_DATA_LOSS)

[sunylf]

全部修復OK了，但查詢時還是出錯啊。
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

(6471 row(s) affected)

第二次以後執行就OK，
換另外的查詢語句執行後，再回到原來的查詢語句就再次出錯。

[sunylf]

分不夠再加，但1天後才能再加，暈。

[nzperfect]

select * FROM vwSOrderZb Z,vwSOrderMx M WHERE Z.SOrderNo=M.SOrderNo
放到sql server 2000的查询分析器里去执行下试试

[xzl_kye]

select Z.*,M.* FROM vwSOrderZb Z,vwSOrderMx M WHERE Z.SOrderNo=M.SOrderNo

[sunylf]

試過不行，間題是有時會出現這個錯誤，有時又正常呢。
想要徹底解決問啊!

[fengb4676]

那这应该是属于SQL的服务问题了吧？试着重新安装下SQL？

[sunylf]

重裝過幾遍SQL了，重裝後可能能管一個月左右吧，一個月後問題又重現了。

[sunylf]

數據庫重做?怎麼個重做法?
UTPCB能祥細點么?

[kk19840210]

这种情况一般是因为 硬件兼容性 和驱动造成的

可以换总方法试下

[sunylf]

兄弟們都來看看啊.這個問題大家都沒有遇到過么?

[utpcb]

你的数据库就有问题！ 建议你 重做数据库吧

[sunylf]

石沉大海了,顶起来.
大家都来帮我看看啊.

[sunygd]

沒人來接分了?
微調基表性能.可以解決.

[nzperfect]

把库换个盘试试呢?

[销魂的拖拉机]

很怀疑系统