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/default.asp?url=/library/en-us/tsqlref/ts_set-set_6d2r.asp
and
SET ARITHABORT
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_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 sets 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 Ansi
> Warnings is a server setting and Arithabort is a db setting?
> Thanks!