June 28, 2006 at 1:33 am
Event Type: ErrorEvent Source: MSSQLServer
Event Category: Server
Event ID: 17052
Date: 22/06/2006
Time: 10:28:51 AM
User: Mine
Computer: Mine123
Description:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 8 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Data:
0000: 00 00 00 00 13 00 00 00 ........
0008: 0b 00 00 00 46 00 4f 00 ....F.O.
0010: 52 00 4d 00 55 00 4c 00 R.M.U.L.
0018: 41 00 2d 00 48 00 52 00 A.-.H.R.
0020: 00 00 05 00 00 00 6d 00 ......m.
0028: 73 00 64 00 62 00 00 00 s.d.b...
June 28, 2006 at 4:00 am
Hi
Go to Sql server log and check for detailed error messages. Also do you find any stacks being generated by sql server in the logs.Also check for the queries which get executed when you run this Pay Roll Process.
June 29, 2006 at 5:48 am
As Arun says, check the SQL Errorlogs. Also check the Windows Event Logs. Try to narrow down what caused the problem, and see if you can identify the root cause.
Ultimately, any problem that causes SQL to crash may need Microsoft help. If you cannot find the cause you will need to raise a case with Microsoft Product Support (see the web for local contact details). Your call may not go far - MS support for Europe and at least some of US is run out of India
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 30, 2006 at 2:34 am
Before calling microsoft, You may perhaps run the SQL trace and check what is happening.
Since the source of error is sql server, the trace may perhaps help you in locating the root cause of the error
July 2, 2006 at 8:35 am
It doesnot look like SQL is crashed because of this error.
you are running SQL 7.0? its pretty old
What is the level of Service Pack you are on? If you look at SQL Error logs you will fine build of SQL Sever. I would say that you should be on latest build (1094)
Please contact me at messenger bmlakhani@yahoo.com
How do you run Payroll process? Its batch submitted to SQL Server? How do you run it?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply