Hi,
Thx 4 answering...
I still can't find a way to change it...when i restart pc, it back to the default option (READ COMMITED), i want to set it permanently to REPEATABLE READ

thx

>See SET TRANSACTION ISOLATION LEVEL in BOL
>
>>
>>How can i change the DEFAULT OPTION of TRANSACTION ISOLATION LEVEL to something else ... I don't want to type all the setting into my sp.