Hi Del,

any ideas as to what gets fixed by reapplying the SP?
I am trying to see if there's anything else we need to fix after installing TDP.

Thanks,
yi

>>> hoobler AT US.IBM DOT COM 10/29/03 08:39AM >>>
Sebastian,

We have seen a hang like this recently when service has been applied
to the operating system. The fix for this has been to apply and/or reapply
the latest service packs to SQL Server. In most cases, this has been to
apply SP3 or SP3a to SQL Server 2000. I see that you are on NT4 and SQL 7.

So, you should make sure the latest service packs are applied to the NT 4
and to the SQL 7 Server. If the problem still persists after doing so,
please call IBM support.

Thanks,

Del

----------------------------------------------------

> current vaules for commtimeout and idletimout are 1200 and 180. i don't
> think that increasing these vaules solve my problem. maybe it will stop
> writing in logs that kind of errors but please remember that i cannot
backup
> up my whole database (ms sql) environment.
> log for that operation (for scheduled operations only) looks like that :