Home Forums Article Discussions Article Discussions by Author Discuss content posted by Nakul Vachhrajani Disabling Indexes RE: Disabling Indexes

  • September 10, 2010 at 3:35 am

    #1219050

    This works on sql 2005... plz. check... you would have commented this line

    ALTER TABLE MyTable DROP CONSTRAINT PK_MyId

    mukeshkane (9/10/2010)

    i have checked the same on sql server 2005 on windows server 2003 but i am getting the error message

    The query processor is unable to produce a plan because the index 'PK_MyId' on table or view 'MyTable' is disabled.

    i think you should check it again.