locked
Issue with Clean AsyncOperationBase job RRS feed

  • Question

  • Team,

    To clean the AsyncOperationbase table in CRM 2011 I have created a job with the following code which I found in

    http://support.microsoft.com/kb/968520?wa=wsignin1.0

    but when I tried to run the job I am getting following error

    Message
    Executed as user: SOLUTIONS\SQLAdmin. CREATE INDEX 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 filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. [SQLSTATE 42000] (Error 1934).  The step failed.

    Can someone give your thoughts on this?

    Thank you,

    Babu

    Wednesday, July 3, 2013 7:12 AM

Answers

  • Hi,

    After doing bit R&D I was able to figure out the solution for the issue.

    I added

    SET QUOTED_IDENTIFIER ON
    GO

    at the Top of the script and

    SET QUOTED_IDENTIFIER OFF
    GO

    at the end of the script.

    Now when I run the job it went fine. no issue

    Hope this helps anyone:)

    Thank you,

    Babu

    Wednesday, July 3, 2013 8:26 AM