|
Home > Archive > MS SQL Server > May 2005 > Row compare failure and Process 3
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Row compare failure and Process 3
|
|
| childofthe1980s 2005-05-31, 8:23 pm |
| 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_VI
OLATION). 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
| |
| SkyWalker 2005-05-31, 8:23 pm |
| There 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/defaul...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_VI
OLATION). 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
|
|
|
|
|