Posted by Hugo Kornelis on 12/11/05 23:21

On Sun, 11 Dec 2005 20:31:37 +0100, stig wrote:

(snip)
> if the query is run, does it commit or
>rollback by default?

Hi Stig,

Sorry - clicked "Send" before answering the last question.

If the query is run, it will commit by default, unless:

a) you explicitly execute a BEGIN TRANSACTION command before it (in that
case, the transaction remains open until you explicitly ROLLBACK or
COMMIT it or until the connection is lost),

b) you have activated the inplicit_transactions option, in which case
SQL Server will act as there is a BEGIN TRANSACTION command even if you
didn't add it yourself, or

c) it aborts due to an error (in that case, it gets rolled back).

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

[Back to original message]