• Since I worked only in 2005 & above i think got it correct. I don't have idea about earlier versions.

    As far as I know anything written between

    BEGIN TRAN

    .

    .

    .

    ROLLBACK

    can be rolled back.

    Please correct me if i'm wrong.

    --
    Dineshbabu
    Desire to learn new things..