title: How to copy data in identity column?
body: <p>I have a table with an <code>identity</code> column in a server and have a other table with same structure in another server.. Now I want to copy all data from one table to other table but I can't help it...</p>
  
  <p>I have already created a linked server..</p>
  
  <p>I use this:</p>
  
  <pre><code>insert into [server].[database].[dbo].[table1]
      select *
      from table2
  </code></pre>
  
  <p>I also use this query without identity column in the place of <code>*</code></p>
  
  <pre><code>insert into [server].[database].[dbo].[table1]
     select column1, column2
     from table2
  </code></pre>
  
  <p>What should I do ?</p>