Query generates "SQLDumpexception…." error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Query generates "SQLDumpexception…." error

USE pubs
go
SELECT *
FROM titles t
RIGHT OUTER JOIN publishers
ON publishers.pub_id=t.pub_id
AND t.ytd_sales = (
SELECT max(ytd_sales)
FROM titles
WHERE publishers.pub_id=titles.pub_id
)
go When I tried to execute this query, I get an error message as follows: "SqlDumpExceptionHandler: Process 81 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process." What is wrong with this query. Please let me know. Regards, Chetan J.
link :http://support.microsoft.com/?kbid=814572
says that the sp3a patch solves the problem.
Are you sure it is SP3a you have there?

" EXCEPTION_ACCESS_VIOLATION " – basically, a piece of sql server code is attempting to access a memory address that it doesn’t own / is owned by another process. Check below link: – http://support.microsoft.com/default.aspx?scid=kb;en-us;288095 if possible can you give us dump file informations. Deepak Kumar –An eye for an eye and everyone shall be blind
]]>