ACCESS VIOLATION ERROR

I have been experiencing a fatal error for one of the SQL
Server services on our development server. Upon
investigating on the internet it would appear that we are
not alone in this. The only fix at present appears to be
a server reboot. The error looks something like:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 56 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process.
Until the server was rebooted, some SQL statements (from
any application) worked and others did not. Very
disturbing when using frames within IE, and the queries
running in the upper frame function correctly and the
queries running in the lower frame bomb out (with an error
message akin to 17066 :SQL Server Assertion: File:
< S:\sql\ntdbms\storeng\drs\include\record
.inl>, line=1447
Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <=
MAXDATAROW'.).
Does anybody know the cause of this error message?
ThanksHi Alex.
That seems to be a SQL Server bug. Do make sure that your development server
is fully up to date with service packs as these types of bugs are regularly
picked up & fixed in service packs.
It might help if you posted what SQL is actually being executed when the AV
occurs. If you could send the query & underlying tables someone might be
able to provide you with an equivalent / alternative query which might be an
easy work-around for your immediate problem. There's really not enough
information in your current post to go off though.
Regards,
Greg Linwood
SQL Server MVP
"Alex" <anonymous@.discussions.microsoft.com> wrote in message
news:14e6201c41571$acde15e0$a501280a@.phx
.gbl...
> I have been experiencing a fatal error for one of the SQL
> Server services on our development server. Upon
> investigating on the internet it would appear that we are
> not alone in this. The only fix at present appears to be
> a server reboot. The error looks something like:
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 56 generated fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
> is terminating this process.
> Until the server was rebooted, some SQL statements (from
> any application) worked and others did not. Very
> disturbing when using frames within IE, and the queries
> running in the upper frame function correctly and the
> queries running in the lower frame bomb out (with an error
> message akin to 17066 :SQL Server Assertion: File:
> < S:\sql\ntdbms\storeng\drs\include\record
.inl>, line=1447
> Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <=
> MAXDATAROW'.).
> Does anybody know the cause of this error message?
> Thanks
>