title: How to create a disabled index in SQL Server 2008?
body: <p>How to create a disabled index in SQL Server 2008? I could first create the index and then disable it, but that is a waste of time if the table is big. How can I create an index in a disabled state directly?</p>
  
  <p>Background information: I want to have two databases to have identical schema objects but I only need the index in one of the two.</p>