DBPROPVAL_TI_READCOMMITTED
A transaction operating at the Read Committed level cannot see changes made by other transactions until those transactions are committed. At this level of isolation, dirty reads are not possible but nonrepeatable reads and phantoms are possible.
DBPROPVAL_TI_READUNCOMMITTED
A transaction operating at the Read Uncommitted level can see uncommitted changes made by other transactions. At this level of isolation, dirty reads, nonrepeatable reads, and phantoms are all possible.
A transaction operating at the Read Committed level cannot see changes made by other transactions until those transactions are committed. At this level of isolation, dirty reads are not possible but nonrepeatable reads and phantoms are possible.
DBPROPVAL_TI_READUNCOMMITTED
A transaction operating at the Read Uncommitted level can see uncommitted changes made by other transactions. At this level of isolation, dirty reads, nonrepeatable reads, and phantoms are all possible.
exec sp_dboption 'dbname','single user',false--设置成多用户
在还不需起事务时就断开.
我检查了数据的配置,没有设置成象 “supsuccess(口气不小)”说的情况。
我是在事务中向数据库中写一个大的二进制文件,在这个过程中
其他对数据库(在事务中操作的表)的访问将被阻塞,有什么办法可以解决吗?