Home Forums SQL Server 2008 SQL Server 2008 - General How To Update NUll Enabled Field Without Interfering With The Rest of the INSERT/UPDATE RE: How To Update NUll Enabled Field Without Interfering With The Rest of the INSERT/UPDATE

  • You could try this in the update audit trigger:

    IF TRIGGER_NESTLEVEL(OBJECT_ID('[<Schema,sysname,dbo>].[<Trigger,sysname,TriggerName>]'), 'AFTER', 'DML') > 0 BEGIN

    -- Triggered by insert trigger ...

    RETURN;

    END

    ... where the trigger-name is that of your insert trigger.