Hi-
I have an OK understanding of the various ISOLATION levels in SQL Server. However, I do have a question.
What's the difference between these 2 Stored Procedure statements.
SET ISOLATION LEVEL SERIALIZEABLE
UPDATE MyTable Set Column1 = 'Updated'
-----------------------------------------
SET ISOLATION LEVEL SERIALIZEABLE
BEGIN TRANSACTION
UPDATE MyTable Set Column1 = 'Updated'
COMMIT TRANSACTION
-----------------------------------------
Essentially, do I need to explicitly begin and commit transactions once I've set the isolation level?
Thanks - B