• As the code didn't display properly updating it correct as below

    Begin transaciton

    --update tablename set column2=1 where column1=56

    -----lots of select code in between no DML

    select * from tablename where column1=56

    ----- lots of select code in between no DML

    --commit transaction

    There is no update and no commit, all it does is a begin tran and a select. (the reason i put the update and commit commented because it was there in the procedure before and commented later but the developer forgot to comment the begin tran.

    Having said the above, what will happen if there is a BEGIN TRAN and followed by a SELECT without commit.

    I have observed no Opentran due to this


    subban