SQL Server Performance Forum – Threads Archive
Query generates "SQLDumpexception…." errorUSE pubs
FROM titles t
RIGHT OUTER JOIN publishers
AND t.ytd_sales = (
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.
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