title: An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON SQL Server
body: <p>I'm trying to do this query </p>
  
  <pre><code>INSERT INTO dbo.tbl_A_archive
    SELECT *
    FROM SERVER0031.DB.dbo.tbl_A
  </code></pre>
  
  <p>but even after I ran</p>
  
  <pre><code>set identity_insert dbo.tbl_A_archive on
  </code></pre>
  
  <p>I am getting this error message </p>
  
  <blockquote>
    <p>An explicit value for the identity column in table 'dbo.tbl_A_archive' can only be specified when a column list is used and IDENTITY_INSERT is ON.</p>
  </blockquote>
  
  <p><code>tbl_A</code> is a huge table in rows and width, i.e. it has a LOT of columns. I do not want to have to type all the columns out manually. How can I get this to work? </p>