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