error adding user when audit trigger applied

Hi I have a trigger that will audit all ddl events. When adding a user
through SSMS and give the user permission to certain databases only not all
databases I get the error below. If I grant access using the code below

CREATE USER [Titan\john.dow] FOR LOGIN [Titan\john.dow]
EXEC sp_addrolemember N'db_datareader', N'Titan\john.dow'

It works totally fine no error messages. Has nayone else had this issue?

thanks for any advice Sammy

Error Msg:
CONDITIONAL 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)

DDL Trigger:

create TRIGGER [TitanDDLTriggerAudit]

ON DATABASE

for DDL_DATABASE_LEVEL_EVENTS

AS

BEGIN

DECLARE @data XML

SET @data = EVENTDATA()

IF @data.value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(100)')

<> 'CREATE_STATISTICS'

if @data.value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(100)')

<> 'UPDATE_STATISTICS'


INSERT dbo.ddlTitanLog

(PostTime, DB_User,DBname, Event, TSQL)

VALUES (GETDATE(), CONVERT(nvarchar(100),

SUSER_NAME()),CONVERT(nvarchar(100),DB_NAME()),
@data.value('(/EVENT_INSTANCE/EventType)[1]',

'nvarchar(100)'),

@data.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'nvarchar(2000)') )

end

sp_configure 'user options', 64
reconfigure

"Sammy" wrote:

> Hi I have a trigger that will audit all ddl events. When adding a user
> through SSMS and give the user permission to certain databases only not all
> databases I get the error below. If I grant access using the code below
>
> CREATE USER [Titan\john.dow] FOR LOGIN [Titan\john.dow]
> EXEC sp_addrolemember N'db_datareader', N'Titan\john.dow'
>
> It works totally fine no error messages. Has nayone else had this issue?
>
> thanks for any advice Sammy
>
> Error Msg:
> CONDITIONAL 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)
>
> DDL Trigger:
>
> create TRIGGER [TitanDDLTriggerAudit]
>
> ON DATABASE
>
> for DDL_DATABASE_LEVEL_EVENTS
>
> AS
>
> BEGIN
>
> DECLARE @data XML
>
> SET @data = EVENTDATA()
>
> IF @data.value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(100)')
>
> <> 'CREATE_STATISTICS'
>
> if @data.value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(100)')
>
> <> 'UPDATE_STATISTICS'
>
>
> INSERT dbo.ddlTitanLog
>
> (PostTime, DB_User,DBname, Event, TSQL)
>
> VALUES (GETDATE(), CONVERT(nvarchar(100),
>
> SUSER_NAME()),CONVERT(nvarchar(100),DB_NAME()),
> @data.value('(/EVENT_INSTANCE/EventType)[1]',
>
> 'nvarchar(100)'),
>
> @data.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'nvarchar(2000)') )
>
> end
>