Why doesn't "set ansi_warnings off" work?

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

miked9999 SSChasing Mays Points: 625 More actions · Answer 1

...and I'm running 2000 Personal Ed + SP2 on Win2k. I was working in a simple QA session logged in as SA.

Simon Sabin SSCrazy Eights Points: 8142 More actions · Answer 2

No cos divide by zero is an error not a warning, warnings are like NULL eliminiated from aggregate

set ansi_warnings off

select sum(cast(null as int))

GO

set ansi_warnings on

select sum(cast(null as int))

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

Simon Sabin SSCrazy Eights Points: 8142 More actions · Answer 3

You need to look at arithabort and arithignore

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

miked9999 SSChasing Mays Points: 625 More actions · Answer 4

So I was looking at grid pane when I should have been looking at the messages pane. Damn I knew it was something simple! Thank U