SQL Server: transactions

go has no effect on transactions.

set transaction isolation level

begin transaction -> @@trancount ++

commit -> @@trancount --

rollback -> @@transcount = 0

@@transcount = 1 -> changes are written to database.

Some of the stuff of this page probable belongs to SQL Server SQL: transactions.

The function xact_state() can be used to determine if a session (?) has an active transaction.

@@trancount counts the nesting level of transactions.

transaction log

The transactional data that is needed to recover a database is stored in log files.