|
|
Posted by Marco van de Voort on 10/02/36 11:48
On 2006-05-22, Erland Sommarskog <esquel@sommarskog.se> wrote:
>
> To wit, if a query times out, and there is a transaction in progress,
> the transaction is not rolled back automatically. It is irrelevant
> whether the transaction was started prior to the submission of the
> query batch, or started within the query batch that timed out.
>
> The application must handle this by submitting
>
> IF @@trancount > 0 ROLLBACK TRANSACTION
I call the rollback of the relevant ADO connection on the exception caused
by the timeout.
Navigation:
[Reply to this message]
|