Please follow this exmple

CREATE TABLE selftest

(Id char(1),

color varchar(50)

)

GO

INSERT INTO selftest SELECT '1', 'Yellow'

INSERT INTO selftest SELECT '1', 'Red'

INSERT INTO selftest SELECT '2', 'Red'

INSERT INTO selftest SELECT '2',...

Yes Sql Server rollback all the process.

Regards

Irshad Vaza

If u want to limit the size log file , the sp_cycle_errorlog system stored procedure can be issued to start a new error log. Depending on the growth rate...

Thanks for this topic. It will be very helpful for me. Developers sometimes do ask those questions of us.

Regards,

Irshad Vaza