Divide by Zero Error OK on select but not insert (SQL 7.0)

[Mark Annulis]

It seems that one cannot ignore Divide By Zero errors when inserting
into a table.
The select part works but trying to insert into a table bombs out.
Anyone have any ideas
about a fix for this or what I'm doing wrong. I had no problems with
this on SQL6.5
Eg..

SET ANSI_WARNINGS OFF
SET ARITHABORT OFF
SET ARITHIGNORE ON
exec('select 7/0')
exec('insert into ##tmptable (Ave) select 7/0')

gives

-----------
NULL

Server: Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Thanks in advance

Steven.