• to do rollback in a right way,

    I wrote:

    -----------------

    BEGIN Tran t1

    DROP TABLE T

    go

    ROLLBACK

    GO

    ----------------

    SELECT * FROM T

    the Question of the Day was wrong, I guess, so, was completed with errors.

    The transaction was used before cross the word "go" so,

    ---------------------------------

    BEGIN Tran t1

    DROP TABLE T

    ROLLBACK

    Tran GO

    ---------------------------------

    rollback doesn't raw