title: Invalid filegroup 'Customers' specified
body: <p>i am creating a database with primary and secondary filegroups. however, when i use sys.filegroups, the secondary filegroups not listed. and also can not create any table under it. please help. </p>
  
  <pre><code>CREATE DATABASE [mydatabase] ON
  PRIMARY 
  (NAME = N'OrderEntryDB', FILENAME = N'C:\SQLData\OEDB.MDF'),
  FILEGROUP Orders
  (NAME = N'OrdersFG1', FILENAME = N'C:\SQLData\OEDB_Orders1.ndf'),
  (NAME = N'OrdersFG2', FILENAME = N'C:\SQLData\OEDB_Orders2.ndf'),
  FILEGROUP Customers
  (NAME = N'CustFG1', FILENAME = N'C:\SQLData\OEDB_Cust1.ndf', 
  SIZE = 5MB, MAXSIZE = 128GB, FILEGROWTH = 5MB)
  LOG ON
  (NAME = N'OrderEntrySBTLog', FILENAME = N'C:\SQLData\OEDBTLog.ldf');
  
  
  
  SELECT * FROM sys.filegroups;
  
  PRIMARY 1   FG  ROWS_FILEGROUP  1   0   NULL    NULL    0   0
  </code></pre>
  
  <hr>
  
  <pre><code>CREATE TABLE cust(cid INT PRIMARY KEY, names varchar(32)) ON Customers;
  </code></pre>
  
  <blockquote>
    <p>Invalid filegroup 'Customers' specified.</p>
  </blockquote>
  
  <hr>
  
  <p>thanks</p>