SchemaAuditDDLTrigger fails on a Create User via SMSS New User

Jun 15, 2009 at 2:35 PM

SchemaAuditDDLTrigger fails when adding a new user to the database via the SMSS New User context menu item.

This fails because ArithAbort needs to be set ON.  Adding new users via the SQL statement CREATE USER works fine because the default options in SMSS has SET ARITHABORT ON.

Fix: Changed trigger to add - SET ARITHABORT ON.

Coordinator
Aug 12, 2010 at 3:50 PM

Fixed in Version 1.10

Coordinator
Aug 12, 2010 at 5:02 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.