Post reply

Integrity check fails on Sharepoint DB Maint Plan

  • July 6, 2005 at 12:10 pm

    #102626

    We have SharePoint running our intranet, and when executing the maint plan we are getting "DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'". Our database default is QUOTED_IDENTIFIER ON. There is a MSFT KB on this (301292), but it doesn't really deal with the case of how to fix the maint plan, just to add some code (SET QUOTED_IDENTIFIER ON) to a SQL Agent job. Any ideas? Thanks.

    There is no "i" in team, but idiot has two.

  • July 6, 2005 at 1:46 pm

    #571481

    The maintenance plan is running a DBCC CHECKDB() for the integrity check. What you would need to do is replace the job that does the Integrity check through the maintenance plan with a job that does the integrity check but using a T-SQL job step. There you could set the QUOTED_IDENTIFIER option before executing the DBCC CHECKDB() command.

    K. Brian Kelley
    @kbriankelley

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

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