changing set option to on from default server level setting

What are some things to watch out for if we change the default settings from
off to on for certain set options.
For eg: if i turn the set aritabort on at a server level, what are the cons
?
> For eg: if i turn the set aritabort on at a server level, what are the cons
That applications that relies on the old default behavior doesn't work correctly anymore. Always set
the setting in your app, and leave the defaults as is.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jamie" <jamesw@.hotmail.com> wrote in message news:etw6jze1FHA.164@.TK2MSFTNGP10.phx.gbl...
> What are some things to watch out for if we change the default settings from off to on for certain
> set options.
> For eg: if i turn the set aritabort on at a server level, what are the cons ?
>

changing set option to on from default server level setting

What are some things to watch out for if we change the default settings from
off to on for certain set options.
For eg: if i turn the set aritabort on at a server level, what are the cons
?> For eg: if i turn the set aritabort on at a server level, what are the con
s
That applications that relies on the old default behavior doesn't work corre
ctly anymore. Always set
the setting in your app, and leave the defaults as is.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jamie" <jamesw@.hotmail.com> wrote in message news:etw6jze1FHA.164@.TK2MSFTNGP10.phx.gbl...[v
bcol=seagreen]
> What are some things to watch out for if we change the default settings fr
om off to on for certain
> set options.
> For eg: if i turn the set aritabort on at a server level, what are the con
s ?
>[/vbcol]