Gary,
That is what I thought. Thank you for confirming it.

Einar

>Einar
>
>In SQL server, a single statement is "contained" in/by an implicit transaction.
>
>>Is it considdered good practice to wrap even singe statements in a transaction. Something like this:
>>

>>BEGIN TRANSACTION
>>UPDATE mytable SET Name = @Name WHERE Id = @Id
>>END TRANSACTION
>>
>>RETURN @@ERROR
>>

>>
>>Or is the transaction simply redundant?
>>
>>Einar