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