Saturday, February 25, 2012

Create Index Causes EXCEPTION_ACCESS_VIOLATION

If we try and create an index on the topics table with domain_id as the key it errors out. The error generated is:
â'SqlDumpExceptionHandler: Process 56 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.â'
I have DBCC CHECKDB, CHECKALLOC and CHECKCATALOG the database. DBCC has not reported any errors.
Any help is appreciated.
Thanks
JLHi Ranjini.
Any time you see a run time dump like that it's likely you've run into a SQL
bug.
However, it may be one that's already fixed by a service pack or hot fix.
What version of sql server are you running? Execute "SELECT @.@.VERSION" so we
get a precise answer please.
If you feel that your service packs (SQL and Windows) are up to date, than
you might want to get in touch with Microsoft PSS for more help.
Regards,
Greg Linwood
SQL Server MVP
"Rajini" <anonymous@.discussions.microsoft.com> wrote in message
news:6D8397D5-ECF8-4338-9BD2-859F2758E271@.microsoft.com...
> If we try and create an index on the topics table with domain_id as the
key it errors out. The error generated is:
> "SqlDumpExceptionHandler: Process 56 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> I have DBCC CHECKDB, CHECKALLOC and CHECKCATALOG the database. DBCC has
not reported any errors.
> Any help is appreciated.
> Thanks
> JL

1 comment:

CALVINALEX said...

This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information... exception_access_violation

Post a Comment