Viewing post 1 (of 2 total)
To continue processing after an error you must turn off XACT_ABORT then check and respond to (or ignore) the error yourself.
DECLARE @iErrorID INT
SET XACT_ABORT OFF
INSERT INTO TABLE
SELECT @iErrorID = @@ERROR
THEN use...
April 2, 2004 at 6:13 am
#501589