Re: missing divide by zero error

Adam Baratz <[email protected]> Thu, 13 Oct 2016 11:07:11 -0400

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<CADxrgCMxSkTvWAs-MwoDPj6eU=B4dp19_ekc7NbAbebBsqW_ug@mail.gmail.com>

>
> Adam attached part of TDSDUMP in the first mail and the server
> is filling severity field with 0:


It turns out you have to call SET ARITHABORT/ARITHIGNORE/ANSI_WARNINGS ON
for these to come back as errors with the correct severity. MS documents
this. I think most of why it's confusing is that SSMS has them enabled by
default. But even with those settings, you still get a result. Mysteries of
TDS...