PRB: @@error Not Set After Overflow or Divide-by-Zero Error

ID: Q105857

The information in this article applies to:

Microsoft SQL Server version 4.2x
Microsoft Windows NT versions 3.1, 3.5, 3.51, 3.51 SP2, 3.51 SP5, 4.0, 4.0 Service Pack 6, 4.0 Service Pack 6a, 4.0 SP4, 5.0

The global variable @@error is not set after a divide-by-zero or aritmetic overflow error. This is independent of ARITHABORT and ARITHIGNORE settings.

SYMPTOMS

Additional query words: Transact-SQL divide by zero Windows NT

Keywords : kbprg kbNTOS310 kbNTOS350 kbNTOS351 kbNTOS400 kbNTOS400sp1 kbNTOS400sp2 kbNTOS500sp3 kbNTOS400sp4 SSrvServer SSrvWinNT kbNTOS400sp6 kbNTOS400sp5
Version : winnt:3.1,3.5,3.51,3.51 SP2,3.51 SP5,4.0,4.0 SP4,4.0 Service Pack 6,4.0 Service Pack 6a,4.2x,5.0
Platform : winnt
Issue type : kbprb