arithabort on

Hello,
How can I check if Arithabort is on?
Thanks,
Jose.DBCC USEROPTIONS
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Jose Ines Cantu Arrambide" <joseine@.nospam.com> wrote in message
news:O39AdhiIEHA.2128@.TK2MSFTNGP11.phx.gbl...
> Hello,
> How can I check if Arithabort is on?
> Thanks,
> Jose.
>|||sp_dboption 'DATABSENAME', 'arithabort'|||Hi Ed
This will only tell you if the option is on at the db level, and the db
setting is ALWAYS overridden by the session level setting,. The dboption is
practically worthless. As Tibor suggested, you can use DBCC USEROPTIONS to
test the session settings.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Ed" <anonymous@.discussions.microsoft.com> wrote in message
news:8E8625DA-C0C5-42A6-85EC-83D370DA6CB6@.microsoft.com...
> sp_dboption 'DATABSENAME', 'arithabort'