title: MSSQL server select into
body: <p>I have a table with 20 millions rows and I need to create another table
  off of it. but <code>select into</code> new table only inserts 100K records.</p>
  
  <p>I have tried select into it and select table as</p>
  
  <pre><code>select * INTO #test
  from dbo.log
  </code></pre>
  
  <p>New table should have 20 millions rows</p>