|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Open Active Transaction
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 |
Open Active Transaction
|
|
| Miguel 2002-11-04, 6:23 am |
| Hi,
Can i abort an Open Active Transaction based on
transaction's duration?
for instance, if i detect an open transaction with more
than 10 minutes i want to abort the transaction.
Thanks
| |
| Uri Dimant 2002-11-04, 6:23 am |
| Miguel
It will be cause filling your log file if you have it
Miguel <cmlcorreia@netcabo.pt> wrote in message
news:576c01c283f6$88fd2480$36e
f2ecf@tkmsftngxa12...
> Hi,
>
> Can i abort an Open Active Transaction based on
> transaction's duration?
> for instance, if i detect an open transaction with more
> than 10 minutes i want to abort the transaction.
>
> Thanks
>
>
| |
| Miguel 2002-11-04, 9:23 am |
| OK, but how can i abort one open transaction based on a
duration? for instance 10 minutes.
Thanks
>-----Original Message-----
>Miguel
>It will be cause filling your log file if you have it
>
>
>Miguel <cmlcorreia@netcabo.pt> wrote in message
> news:576c01c283f6$88fd2480$36e
f2ecf@tkmsftngxa12...
>> Hi,
>>
>> Can i abort an Open Active Transaction based on
>> transaction's duration?
>> for instance, if i detect an open transaction with more
>> than 10 minutes i want to abort the transaction.
>>
>> Thanks
>>
>>
>
>
>.
>
|
|
|
|
|