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!

-----Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson

Carla Wilson (10/7/2008)Wayne,Wow, good job investigating system tables/views and triggers! (although I did not expect you to drop everything to do it - - I was just reply to your question.)Your testing is much appreciated.

Finished the 2005 attempt: fail with the following message:

Msg 8197, Level 16, State 6, Procedure tr_syscolumns, Line 1Object '_syscolumns' does not exist or is invalid for this operation.

Got the same error before trying to slide past it with view.

It seems to me that it should be possible. I glanced at this article here on SSC, so maybe it's possible, perhaps I just need to work at it a bit more.

:D

-----Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson