title: Error after disable Index in a table
body: <p>I would like to do Bulk Insert, but it takes a long time. My Idea is to disable Index on the table, to do INSERTs a little bit faster. But after that I get this error:</p>
  
  <blockquote>
    <p>Error: The query processor is unable to produce a plan because the index <code>CRMD_MKTTG_TG_I~0</code> on table or view '<code>CRMD_MKTTG_TG_I</code>' is disabled.</p>
  </blockquote>
  
  <p>I am generating my table with this script:</p>
  
  <pre><code>SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  SET ANSI_PADDING ON
  GO
  
  CREATE TABLE [CRMD_MKTTG_TG_I](
      [CLIENT] [nvarchar](3) NOT NULL,
      [GUID] [varbinary](16) NOT NULL,
      [TG_GUID] [varbinary](16) NULL,
      [BP_GUID] [varbinary](16) NULL,
      [BP_ORG] [nvarchar](2) NOT NULL,
      [BP_DEL] [nvarchar](1) NOT NULL,
      [REL_GUID] [varbinary](16) NULL,
      [RELATIONSHIP] [nvarchar](6) NOT NULL,
      [TYPE_BP_GUID] [nvarchar](1) NOT NULL,
      [TYPE_REL_GUID] [nvarchar](1) NOT NULL,
      [ROW_NUMBER] [int] NOT NULL,
   CONSTRAINT [CRMD_MKTTG_TG_I~0] PRIMARY KEY CLUSTERED 
  (
      [CLIENT] ASC,
      [GUID] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  
  GO
  
  SET ANSI_PADDING OFF
  GO
  </code></pre>
  
  <p>any idea?</p>