title: Partitioning Table Error with more partitions than Filegroups
body: <p>I am trying to partition a DB table, I have created the filegroups correctly (I think), I had to add a couple of extra filegroups along the way as I had an error with the amount of partitions compared to filegroups (I have trouble getting my head round this), I have created a partition function without problem, but when I try to create the partition scheme I get the following error:</p>
  
  <blockquote>
    <p>Msg 7707, Level 16, State 1, Line 2
    The associated partition function
    'PARTFN_INV_LINE_FACT' generates more
    partitions than there are file groups
    mentioned in the scheme
    'PARTSCH_INV_LINE_FACT'.</p>
  </blockquote>
  
  <p>Have I missed a step?</p>
  
  <p>I am new and doing this to learn for a future task, so please excuse me if I haven’t given enough information. I have included everything I have done below.</p>
  
  <p>All filegroups have to be explicitly entered in the scheme.   </p>