title: How to copy table data from remote server to Local server in SQL Server 2008
body: <p>I am trying to copy all table data from server to my local database, like </p>
  
  <pre><code>INSERT INTO [.\SQLEXPRESS].[Mydatabase]..MYTable
     SELECT * 
     FROM [www.MYSite.com].[Mydatabase]..MYTable
  </code></pre>
  
  <p><code>www.MYSite.com</code> having <code>SQL LOGIN ID XYZ</code> AND <code>PASSWORD 1234</code></p>
  
  <p>but I get an error:</p>
  
  <blockquote>
    <p>Could not find server 'www.MYSite.com' in sys.servers.<br>
    Verify that the correct server name was specified. If necessary,<br>
    execute the stored procedure sp_addlinkedserver to add the server to sys.servers.</p>
  </blockquote>
  
  <p>I want to copy all the data from <code>Mytable</code> of <code>www.MYSite.com</code> to <code>Mytable</code> of <code>.\SQLExpress</code>.</p>
  
  <p>How to resolve it? Please help.</p>
  
  <p><strong>Update :</strong></p>
  
  <p>I am using <strong>Microsoft Sync Framework 2.0</strong> to sync all data from <code>www.MYSite.com</code> to <code>.\SQLExpress</code> and vice versa, but in a one condition I want to copy data from <code>www.MYSite.com</code> to <code>.\SQLExpress</code> without sync framework</p>
  
  <p>Please Note I am passing those SQL Statement using C#..</p>