Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tikus
Starting Member
31 Posts |
 Posted - 2005-03-31 : 12:38:19
|
| Hello, in the SP, when I use Set Transaction Isolation Level XXXXX, do I need to use BEGIN TRAN and COMMIT TRAN to make the isolation level taking effect? |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-03-31 : 13:05:03
|
| It's two different things.You use BEGIN TRAN, COMMIT, ROLLBACK to define the scope of your transactions.The isolation level that the transactions run in (SET TRANSACTION ISOLATION LEVEL xxx)dictates how locks will be taken and data protected inside a transaction.The higher the isolation level, the more data will be locked down during the transaction.A: Yesrockmoose |
 |
|
|
|
|
|
Set Transaction Isolation level