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

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

Q105857

The information in this article applies to:

Microsoft SQL Server version 4.2x
Microsoft Windows NT Server versions 3.1, 3.5, 3.51, 3.51 SP2, 3.51 SP5, 4.0, 4.0 SP6, 4.0 SP6a, 4.0 SP4
Microsoft Windows NT Workstation versions 3.1, 3.5, 3.51, 3.51 SP2, 3.51 SP5, 4.0, 4.0 SP6, 4.0 SP6a, 4.0 SP4

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 : kbprogramming kbOSWinNT310 kbOSWinNT350 kbOSWinNT351 kbOSWinNT400 kbOSWinNT400sp1 kbOSWinNT400sp2 kbOSWinNT400sp3 kbOSWinNT400sp4 kbOSWinNT400sp6 kbOSWinNT400sp5
Issue type : kbprb
Technology : kbWinNTsearch kbWinNTWsearch kbWinNTW400 kbWinNTW400search kbWinNT351xsearch kbWinNT350xsearch kbWinNT400xsearch kbWinNTW350 kbWinNTW350xsearch kbWinNTW351xsearch kbWinNTW351 kbWinNTW400sp4 kbWinNTW310 kbWinNTSsearch kbWinNTS400sp6 kbWinNTS400sp4 kbWinNTS400xsearch kbWinNTS400 kbWinNTS351 kbWinNTS350 kbWinNTS310 kbWinNTS351xsearch kbWinNTS350xsearch kbWinNTS310xsearch kbWinNTS351sp2 kbWinNTS351sp5 kbSQLServSearch kbAudDeveloper kbWinNT310xSearch kbWinNTW310Search kbWinNTW351sp5 kbWinNTW400sp6 kbWinNTW351SP2 kbWinNTW400SP6a kbSQLServ420OS2