title: Export table data from one SQL Server to another
body: <p>I have two SQL Servers (both 2005 version).</p>
  
  <p>I want to migrate several tables from one to another.</p>
  
  <p>I have tried:</p>
  
  <ul>
  <li><p>On source server I have right clicked on the database, selected <code>Tasks/Generate scripts</code>.
  The problem is that under <code>Table/View options</code> there is no <code>Script data</code> option.</p></li>
  <li><p>Then I used <code>Script Table As/Create script</code> to generate SQL files in order to create the tables on my destination server. But I still need all the data.</p></li>
  </ul>
  
  <p>Then I tried using:</p>
  
  <pre><code>SELECT * 
  INTO [destination server].[destination database].[dbo].[destination table] 
  FROM [source server].[source database].[dbo].[source table]
  </code></pre>
  
  <p>But I get the error:</p>
  
  <blockquote>
    <p>Object contains more than the maximum number of prefixes. Maximum is
    2.</p>
  </blockquote>
  
  <p>Can someone please point me to the right solution to my problem?</p>