EXCEPTION_ACCESS_VIOLATION Error 17883

We installed a Server 2003 Standard and SQL 2000 Sp3a
This is a replace of an NT4 Server With SQL 7.
The application has never had SQL related problems,
Now after 4 hours live production the SQL Server hung with dumps in the SQL
log's starting one hour before complete hung.
Errormessages :
Error 17883
EXCEPTION_ACCESS_VIOLATION
The sheduler appeers to be hung
Then a dump in the log
Same select statement with the same spid
over and again for about one hour then complete stop of SQL 2000
Customer not very pleased an lots of stress for the technical guys and the s
oftware guys.
Also Errors in the Application Log for SQL Server.
The machine is an Xeon Processor 2.8 Ghz (Server 2003 sees it as a dual proc
essor machine)
2 GB of Memory
360 MB dedicated for SQL 2000
100 GB raid 5 hard disk U320
Database size 450 MB
Happens on a simple select statement.
Thanks a lot
Luc VanleeuwI have had the same thing happen to me and after some research found the
following article:
http://support.microsoft.com/default.aspx?kbid=810885
I too just moved to Windows 2003 server with SQL and applied SP3a. I think
when I applied this patch it "blew away" my previous patch installation of
MS03-031: Cumulative Security Patch for SQL. I am going to apply this
tonight and see if it fixes my problem...let you know...or let me know if
you have any luck...
Jim
"Luc Vanleeuw" <anonymous@.discussions.microsoft.com> wrote in message
news:5AFD1596-C167-407C-9DBC-F01712DE600F@.microsoft.com...
> We installed a Server 2003 Standard and SQL 2000 Sp3a
> This is a replace of an NT4 Server With SQL 7.
> The application has never had SQL related problems,
> Now after 4 hours live production the SQL Server hung with dumps in the
SQL log's starting one hour before complete hung.
> Errormessages :
> Error 17883
> EXCEPTION_ACCESS_VIOLATION
> The sheduler appeers to be hung
> Then a dump in the log
> Same select statement with the same spid
> over and again for about one hour then complete stop of SQL 2000
> Customer not very pleased an lots of stress for the technical guys and the
software guys.
> Also Errors in the Application Log for SQL Server.
> The machine is an Xeon Processor 2.8 Ghz (Server 2003 sees it as a dual
processor machine)
> 2 GB of Memory
> 360 MB dedicated for SQL 2000
> 100 GB raid 5 hard disk U320
> Database size 450 MB
> Happens on a simple select statement.
> Thanks a lot
>
> Luc Vanleeuw
>