Post reply

set quoted_identifier on ...problems

  • August 19, 2008 at 8:37 am

    #382302

    SET QUOTED_IDENTIFIER ON

    im setting this on in a stored proc, java code executes the stored proc... i'm getting the following error

    can anyone offer some advice?

    Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: SELECT INTO failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. 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.

    Thanks

  • August 19, 2008 at 9:06 am

    #860070

    it might possibly be because im extracting node values from XML contained in a column from one of the tables... any ways around this....

  • August 19, 2008 at 9:42 am

    #860099

    anyone??

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

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