Not sure what OS Patch may have cause this,

I have a production server that it's returning this error in my application, to any user of the application during any transaction.

The only workaround I was able to to was to put everyuser as an Administrator of the Database and the error stopped, for obvious reasons cant leave it like that ... but cant seem to replicate the issue on my test environment.

Any Ideas ...

I tried ... replacing SQLSort.dll as one article mentiones

Subject: SQL Server Alert System: 'Demo: Sev. 19 Errors' occurred on \SEVERNAME

DATE/TIME: 4/29/2010 5:23:44 PM

DESCRIPTION: Error: 0, Severity: 19, State: 0 SqlDumpExceptionHandler: Process 193 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

more ▼

asked May 03, 2010 at 04:08 PM in Default

avatar image

1 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

This may not be a solution but I have seen the need for re-application of service packs after OS updates. Have you re-applied the latest sp for SQL 7?

What sort of application - web, client hosted/installed, server hosted/installed ..?

Is there any option to upgrade?

more ▼

answered May 03, 2010 at 05:20 PM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

Thank you Fatherjack ! We will try to reapply the SP 4 maybe that works, I'll keep posting updates. The application is not a web application is Client/Server Thanks again ...

May 03, 2010 at 06:41 PM Vinnie
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 03, 2010 at 04:08 PM

Seen: 1803 times

Last Updated: May 03, 2010 at 04:08 PM

Copyright 2018 Redgate Software. Privacy Policy