Post reply

Rebuild index failing

  • January 22, 2010 at 2:50 pm

    #215950

    I am using below code on SQL 2008 (Build 2531) to rebuild index and it is throwing below error:

    Msg 50000, Level 16, State 1, Procedure ddl_changes, Line 91

    change to INDEX [dbo].[PK_XXXXXX] must be made with a change_reason.

    Msg 3609, Level 16, State 2, Line 1

    The transaction ended in the trigger. The batch has been aborted.

    Can anyone please advice?


    CDBA

  • January 22, 2010 at 3:00 pm

    #1107609

    Not sure, but sounds like some form of Policy Based Management is being used.

    EDIT: Or there is a DDL Trigger in place and something is missing.

  • January 22, 2010 at 3:19 pm

    #1107620

    It seems there is a DDL trigger that is aborting such operations. Check with the Sr DBA if you can be allowed to Disable Triggers otherwise you will keep getting these errors.

    Thanks...

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

  • January 23, 2010 at 6:09 am

    #1107739

    Thanks folks. Found a trigger


    CDBA

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

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