Row compare failure and Process 3

Hello:
We are on SQL Server 7.00.1063 (SP4) and Windows 2000 5.00.2195 (SP4).
I had to reboot our server this AM as SQL Server was not responding. It
seems to be fine, now.
Afterward, I reviewed the Windows 2000 Server Log in Event Viewer and ran
across a couple of things. Could someone please let me know if there is
something that I should do based on these statements, in hopes of preventing
this problem from happening again?
For last Friday, a message says Process 3 generated fatal exception
(EXCEPTION_ACCESS_VIOLATION). For last Sunday, a message says "Row compare
failure".
I'm not sure on these, but if someone could shed some insight, that would be
great!
Thanks!!!
childofthe1980sThere could be a memory leak issue if you use BULK INSERT.
If this is the case use BCP instead to avoid it.
There is more information:
http://support.microsoft.com/default.aspx?scid=kb;en-us;246824
Regards.
"childofthe1980s" wrote:
> Hello:
> We are on SQL Server 7.00.1063 (SP4) and Windows 2000 5.00.2195 (SP4).
> I had to reboot our server this AM as SQL Server was not responding. It
> seems to be fine, now.
> Afterward, I reviewed the Windows 2000 Server Log in Event Viewer and ran
> across a couple of things. Could someone please let me know if there is
> something that I should do based on these statements, in hopes of preventing
> this problem from happening again?
> For last Friday, a message says Process 3 generated fatal exception
> (EXCEPTION_ACCESS_VIOLATION). For last Sunday, a message says "Row compare
> failure".
> I'm not sure on these, but if someone could shed some insight, that would be
> great!
> Thanks!!!
> childofthe1980s