SqlDumpExceptionHandler: 进程 55 发生了严重的异常 c0000005 EXCEPTION_ACCESS_VIOLATION。SQL Server 将终止该进程。
情况描述 如下一条SQL
Select VW_InvGoods.GoodsID, A.PositionID, VW_InvGoods.Goodscode, VW_InvGoods.GoodsName, InvPosition.PosName, A.InOutQty, B.InvQty
from VW_Invgoods Inner join
(SELECT GoodsID, PositionID, SUM(inOut * Qty) AS InOutQty
FROM InvInOutLog
Group by GoodsID, PositionID) A
On VW_InvGoods.GoodsID = A.GoodsID Inner join
(Select GoodsID, posID ,Sum(SumQty) as InvQty
from InvGoodStorage
Group by GoodsID,posID) B
On VW_InvGoods.GoodsID = B.GoodsID Left join invPosition
On A.PositionID = invPosition.PosID
Where A.InOutQty = B.InvQty and A.GoodsID = B.GoodsID and A.PositionID = B.posID
1 在本机(TSP)A数据库能执行
2 在本机B数据库弹出文章标题错误,但去掉Where、或者Where A.InOutQty = B.InvQty and
A.GoodsID = B.GoodsID、或者Where A.GoodsID = B.GoodsID and A.PositionID = B.posID等,
就是三个条件、或者Where A.InOutQty = B.InvQty and A.PositionID = B.posID就会出错
3 在本机B数据库备份到另一电脑(Server)还原,再执行不会出错.
3 在本机B数据库备份还原到本机B1数据库,不能执行。
备注:本机(TSP) 与 电脑(SERVER)的SQL SERVER 2000 版本号都为8.00.760
请教如何解决这个问题.