Post reply

"INSERT failed because the following SET options have incorrect 'ANSI_PADDING' settings:

  • September 11, 2008 at 8:33 am

    #96531

    Hi,

    We have implemented one trigger to track user changes in our database but when ever user run alter query they get the following error

    but if we run alter query in other database where same trigger is implemented its not giving error

    INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. 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"

    So pls help me.

    Waiting for ur kind reply.

  • September 11, 2008 at 9:06 am

    #870394

    It is what it said. You likely created the trigger with different SET settings than the table.

    Change ANSI_PADDING, redo the trigger and then it should be OK.

  • September 11, 2008 at 9:36 am

    #870422

    Steve thanks for the reply, but the same code has been implemented in others servers also.

    The code contiains the ansi padding setting before the create trigger line.

    Same thing has been implenmented in other database.

    Any idea?

  • September 11, 2008 at 9:42 am

    #870426

    If ANSI_DEFAULT are OFF on the server level, ANSI_PADDING in trigger will give you an error message.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply