March 9, 2010 at 8:39 am
Hi, Please help me to solve this situation.
We are running a SQL2008 Enterprise Server, 64 bits, SQL_1xCompat_CP850.
In Security/Login Poperties, when I map a certain Database to an User, I get the followin error:
SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. (.Net SqlClient Data Provider)
I checked that ARITHABORT is false
select a.name,
a.is_arithabort_on Xarithabort,
a.is_ansi_warnings_on Xansi_warnings,
a.is_concat_null_yields_null_on Xconcat_null_yields_null
from sys.databases a
where
a.is_arithabort_on <> 0 or
a.is_ansi_warnings_on <> 0 or
a.is_concat_null_yields_null_on <> 0 returns no Rows
DBCC checkdb doesn't throw errors. I reindexed all tables. I did a Backup/Restore the database.
The error occurs with any User on that db.
I'm out of ideas, please, could anyone help me with this issue?
Thanks,
Nicolas
March 9, 2010 at 10:51 am
Hi, I found in http://support.microsoft.com/kb/305333 some hints. So I tried out to set the db option ARITHABORT to TRUE.
And voila, it worked!
I authoized my Logins properly y got back ARITHABORT to FALSE.
I think, it has to be some internal issue, using indexed views when it updates the Login attributes.
Hope it can be of use to someone else.
Nicolas
🙂
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply