ERROR:"SQL Server is terminating this process"?? [pls help~]
-
i not sure wat this error mean it just not working with my SQL
ODBC: Msg 0, Level 19, State 1 SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. Connection BrokenHere is my SQL command, the underline code which i added then the error came out. B4 add the command so working correctlySELECT Query1.bizdate, TSuper,TSoft, THard, (TSoft+ THard+ TSuper) as TOTAL , ((TSoft+ THard+ TSuper)-(TsCost+ThCost+TsuCost))as GP FROM (SELECT bizdate, SUM(totalsales+returnamt) AS TSoft ,sum(totalcost+returncost)as TsCost FROM tot_item WHERE deptcode IN (11, 12, 13, 14, 15, 16, 17) GROUP BY bizdate) AS Query1 LEFT JOIN (SELECT bizdate, SUM(totalsales+returnamt) AS THard ,sum(totalcost+returncost)as ThCost FROM tot_item WHERE deptcode IN (21, 22, 23, 24, 25, 26, 27, 28, 29) GROUP BY bizdate) AS Query2 ON Query1.bizdate = Query2.bizdate LEFT JOIN (SELECT bizdate, sum(totalsales+returnamt) AS TSuper ,sum(totalcost+returncost)as TsuCost FROM tot_item WHERE deptcode IN (30, 40, 50, 60, 70, 80, 90) GROUP BY bizdate) AS Query3 ON Query1.bizdate = Query3.bizdate where query1.bizdate>= '2006-10-01' and query1.bizdate<= '2006-10-15' order by query1.bizdate -
i not sure wat this error mean it just not working with my SQL
ODBC: Msg 0, Level 19, State 1 SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. Connection BrokenHere is my SQL command, the underline code which i added then the error came out. B4 add the command so working correctlySELECT Query1.bizdate, TSuper,TSoft, THard, (TSoft+ THard+ TSuper) as TOTAL , ((TSoft+ THard+ TSuper)-(TsCost+ThCost+TsuCost))as GP FROM (SELECT bizdate, SUM(totalsales+returnamt) AS TSoft ,sum(totalcost+returncost)as TsCost FROM tot_item WHERE deptcode IN (11, 12, 13, 14, 15, 16, 17) GROUP BY bizdate) AS Query1 LEFT JOIN (SELECT bizdate, SUM(totalsales+returnamt) AS THard ,sum(totalcost+returncost)as ThCost FROM tot_item WHERE deptcode IN (21, 22, 23, 24, 25, 26, 27, 28, 29) GROUP BY bizdate) AS Query2 ON Query1.bizdate = Query2.bizdate LEFT JOIN (SELECT bizdate, sum(totalsales+returnamt) AS TSuper ,sum(totalcost+returncost)as TsuCost FROM tot_item WHERE deptcode IN (30, 40, 50, 60, 70, 80, 90) GROUP BY bizdate) AS Query3 ON Query1.bizdate = Query3.bizdate where query1.bizdate>= '2006-10-01' and query1.bizdate<= '2006-10-15' order by query1.bizdateContact Microsoft support. There's a bug somewhere in your copy of SQL Server which is causing an error to occur in the database engine. You should first ensure that you're running one of the supported service packs. For SQL Server 2000 this is SP3a or SP4, for SQL Server 2005 it's either the original (RTM) release or SP1.
Stability. What an interesting concept. -- Chris Maunder
-
Contact Microsoft support. There's a bug somewhere in your copy of SQL Server which is causing an error to occur in the database engine. You should first ensure that you're running one of the supported service packs. For SQL Server 2000 this is SP3a or SP4, for SQL Server 2005 it's either the original (RTM) release or SP1.
Stability. What an interesting concept. -- Chris Maunder
Mike what you pointed out could be the reason. But this need not be the so in this case. MS KB Article ID: 892451 might have been what you were referring to. The dump also occurs in case of excessive memory usage.
Thanks and Regards, Aby