Simon, thanks for the response.
I'm not sure I understand your question -
as far as I know, MSSQL will
rollback the transaction immediately, >>
It means : I want to know for sure how many seconds
is it from connection failure to the beginning
of rollback.
but why would you want to delay
the rollback? >>
No, I do not want to delay it.
If possible, I want to make the delay short,
as short as possible by adjusting any parameters
(like in Novell Netware : "number of watchdog -
packets", "delay between watchdog packets").
Perhaps if you can explain what problem you are trying
to solve, someone will be able to make a suggestion. >>
Currently, I have no problem. It is only a question.
I also want to ask :
If I found that SQL Server took long to rollback
an uncommitted small transaction caused by a network
failure, what should I do ?
Regards
John S.
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!