Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mits
Starting Member
48 Posts |
 Posted - 2006-05-30 : 11:37:11
|
| Hi all,Our production server had a raid failure, which we fixed overnight.This is where the problem started, at least i think.Now all of a sudden(after the server was restarted) i am getting following error, when one of the stored procedure gets executed(I have more then 200 Stored Procedure and they are all working fine)It does not throw error everytime it gets executed, but randomly it will fail."SqlDumpExceptionHandler: Process 233 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process"This error also creats a dump file in \MSSQL\Log and logs into SQL Error Log.I also did DBCC CHECKDB suggested by many people on Internet and everything seems fine, in terms of data corruption.CHECKDB found 0 allocation errors and 0 consistency errors in database 'XXXX'.I even tried dropping and recreating the stored procedure, but same result and no luck.My question is why all of a sudden or server re-start would trigger this errors? By the way I am using VB.Net 2003 and SQL Server 2000. My only fear is that our SQL server does not have latest service pack.Any ideas or suggestion will be highly appreciated.Mits |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-05-31 : 15:12:42
|
| You need to call Product Support to find out why the AV is happening.Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine + SQL Express(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
|
|
|
Exception_Access_Violation Error?