• good question.

    when SET IMPLICIT_TRANSACTIONS off it will shows two times and other wise if we put SET IMPLICIT_TRANSACTIONS on then second time it shows "invalid object".This is due to SET IMPLICIT_TRANSACTIONS off.

    good explanation.

    Malleswarareddy
    I.T.Analyst
    MCITP(70-451)