You should.
Otherwise, you could run into situations, where you insert stuff
somewhere at the beginning, and later in the script select it again, but
getting "old" data, because you are still in the same transaction, using
the snapshot from before your insert.

Using explicit transactions prevents this.

[Alan McDonald] This can't be Thomas - the default would allow you to see
what you inserted. My problem would be that is there is a transaction start
without an explicit commit, then you may end up doing a rollback without
knowing
Alan


[Non-text portions of this message have been removed]