Post reply

Problems with indexed views and Inserts

  • April 14, 2004 at 1:56 pm

    #179172

    Hi to all:

             I have a stored procedure wich inserts into a table referenced by an indexed view. I get the following error:

    INSERT failed because the following SET options have incorrect settings:
    `QUOTED_IDENTIFIER_,ARITHABORT`
     
    I have already check the article in
     
    The application uses the default db settings for QUOTED_IDENTIFIER and ARITHABORT (bad practice), wich are OFF.
    But to create the indexed views, these options are ON.
     
    MS Article suggest to modify the app to specify the ON option in the source code, wich is not a very pleasent solution for me.
     
    Changing the default settings of the db, woudn't also give me the solution?
    What problems can bring to the application?
     
    thanks in advanced to all.
     
    Rodrigo.

  • April 14, 2004 at 7:34 pm

    #502837

    Hi,

    Try change Aritmethic abort setting from connection property.

    1. Run SQL Server Enterprise Manager

    2.right klick on server, select properties

    3.select connection tab

    4. check mark on ANSI warning,ANSI padding,ANSI nulls, Aritmethic abort

     

  • April 15, 2004 at 6:23 am

    #502900

    Script out the proc and check the quoted_identifier and arithabort settings on the create procedure statement.


    Shamless self promotion - read my blog http://sirsql.net

  • April 15, 2004 at 9:12 am

    #502967

    Please, before posting possible solutions, check microsft link in my first post.

     

    I have created the indexed views with the options sets to ON and didn't work. Now I have change database defaults (wich where OFF) to On, because the development team confirm me that changing the db defaults woudn't affect the application.

    Don't know if its gonna work yet.

     

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

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