Ive seen lots of posts here regarding "insert failed because the following Set options have the incorrect settings: 'Arithabort' ".
I use Indexed Views because Im replicating to a denormalized table so the schema is different on the Subscriber than the Publisher. I know that the above setting needs to be set in its own batch in the create of the Indexed View so thats what I do:
SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
set arithabort on
alter view vu_ReplTransDTL
bla bla bla
Now this works to insert data directly in the table that the view references either in Enterprise Manager or a Stored Proc. But it doesnt work if I try to DTS data into the table from another source. Or if I try to use Replication to poulate from another source. I still get the same error message under these circumstances. Ive read that ARITHABORT needs to bet set ON during the createion of the Procs that insert data into the table. But how can that happen for DTS or Replication? Do people just not use these tools for a scenario like this?