Data modification queries and isolation level

[newbby]

Hi All,
A. What should the transaction isolation level be set to in select/insert/update/delete queries if I DONOT have a BEGIN TRAN, COMMIT/ROLLBACK set(BEGIN TRAN is not needed in select queries)?
B. What should the transaction isolation level be set to in select/insert/update/delete queries if I DO have a BEGIN TRAN, COMMIT/ROLLBACK set(BEGIN TRAN is not needed in select queries)?
Thanks

 

[vongrunt]

Hm... BEGIN/COMMIT TRAN is not necessary for single DML statement. And if you don't have a BEGIN TRAN but should have, no isolation level will help - anyone can modify data before batch is completed.