Re: named transaction
From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 02/07/05
- Next message: Andy: "Re: Difference between = and IN"
- Previous message: Hugo Kornelis: "Re: Difference between = and IN"
- In reply to: Malgorzata Ndreu: "named transaction"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 07 Feb 2005 12:40:26 +0100
On Mon, 7 Feb 2005 09:20:43 +0100, Malgorzata Ndreu wrote:
>Hi,
>I need to make sure i do not open second transaction if one is already
>opened,
Hi mndreu,
Check @@TRANCOUNT.
>i wanted to name a transaction, but how can i cjeck if a transaction with
>that name is already open?
If @@TRANCOUNT is 0, no transaction at all is open.
If @@TRANCOUNT is > 0, I know of no way to check if the open transactions
are named and what their names are.
Best, Hugo
-- (Remove _NO_ and _SPAM_ to get my e-mail address)
- Next message: Andy: "Re: Difference between = and IN"
- Previous message: Hugo Kornelis: "Re: Difference between = and IN"
- In reply to: Malgorzata Ndreu: "named transaction"
- Messages sorted by: [ date ] [ thread ]
