Transaction message

Question

In activity monitor the process details shown as ] "SET TRANSACTION ISOLATION LEVEL READ COMMITTED;BEGIN TRANSACTION".what does it means?

Answer 1

check this link of msdn : SET TRANSACTION ISOLATION LEVEL

READ COMMITTED

Specifies that shared locks are held while the data is being read to avoid dirty reads, but the data can be changed before the end of the transaction, resulting in nonrepeatable readsor phantom data. This option is the SQL Server default.

Answer 2

Google it

Isolation (database systems)

Stackoverflow:ISOLATION levels in Transaction