10-30-02, 12:28 #1Registered User
- Join Date
- Jan 2002
Unanswered: How to have Cursor continue fetching after error?
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)