• Hugo Kornelis (10/1/2010)


    The description of the effects of ROLLBACK in a trigger is word for word the same for the current version and for SQL Server 2000.

    See http://msdn.microsoft.com/en-us/library/ms181299.aspx and http://msdn.microsoft.com/en-us/library/aa238433%28SQL.80%29.aspx.

    I agree. I work both with sql2000 and sql2005 and the behavior is the same.

    Results may be different if this option is set SET IMPLICIT_TRANSACTIONS ON