title: Try to create a table from Select - SqL Server 2008 throws error
body: <p>Hi I am trying to create a table using inner select statement...</p>
  
  <p>for example: </p>
  
  <pre><code>CREATE TABLE JmxMonSer AS (SELECT * FROM services WHERE monitoring_enabled = 1);
  </code></pre>
  
  <p>But keep getting error:</p>
  
  <blockquote>
    <p><em>Incorrect Syntax near keyword 'AS', Severity 15</em></p>
  </blockquote>
  
  <p>please advice</p>