Easy Question

What's the difference between Ansi warnings and Arithabort. Is it that Ansi
Warnings is a server setting and Arithabort is a db setting?
Thanks!Kath,
ANSI WARNINGS is a database option; ARITHABORT is a session setting.
See:
SET ANSI_WARNINGS
http://msdn.microsoft.com/library/d... />
t_6d2r.asp
and
SET ARITHABORT
http://msdn.microsoft.com/library/d... />
t_5tys.asp
HTH
Jerry
"Kath" <Kath@.discussions.microsoft.com> wrote in message
news:64154353-D3A0-4570-BD86-5B702FB56A04@.microsoft.com...
> What's the difference between Ansi warnings and Arithabort. Is it that
> Ansi
> Warnings is a server setting and Arithabort is a db setting?
> Thanks!|||ANSI_WARNING exists as a session setting. It is documented in Books Online,
SET.
ARITHABORT exists as a session setting. Documented.
ANSI_WARNING exists as a database setting. It is documented in Books Online,
ALTER DATABASE.
ARITHABORT exists as a database setting. Documented.
Database settings should not be relied upon. Some programming environments s
ets these without the
programmers knowledge. And some dba will set these to that the applications
doesn't work correctly.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Kath" <Kath@.discussions.microsoft.com> wrote in message
news:64154353-D3A0-4570-BD86-5B702FB56A04@.microsoft.com...
> What's the difference between Ansi warnings and Arithabort. Is it that Ans
i
> Warnings is a server setting and Arithabort is a db setting?
> Thanks!sql