Giovanny Gomez Convers (10/7/2008)
Hi!,When I try delete a user on database, appears the next error message:
"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 query notifications and/or xml data type methods. (.Net SqlClient Data Provider)"
The Trigger is the reason for this message?
tks.
I have no problem adding or deleting a user to my DDL audited database. I'd suggest two things. First, check your audit table to make sure the data types are the same as in the article. You might want to change any char or varchar to nchar or nvarchar. Second, look up ARITHABORT in BOL, there are some database-specific configurations that can cause it to abort a transaction.
Good luck!
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]