Is there a way to have a cursor continue to fetch from a recordset after an error is encountered due to one of the records? I have been testing this and it always rollsback the entire batch when an error occurs in the middle of the recordset.

(SQL Server 2000 sp2)