Monday, March 19, 2012

Index on Binary Checksum column

I've created a column with binary_checksum, then create an index on that particular column.

When I'm using DTS to transfer some data into that table, I've got this error message:

INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'

any leads?

ThanksI've done a normal insert via query analyser, it works fine.

Odd, after I removed the index, iDTS insert works fine again. :|
Is this a DTS bug? Or are there any settings in DTS I have to configure?

No comments:

Post a Comment