title: sp_addlinkedserver syntax
body: <p>I would like to make a copy of what's on my remote server at xxx.safesecureweb.com.
  How do I connect to it from my local SQL Server?</p>
  
  <p>Is the syntax something like:</p>
  
  <pre><code>sp_addlinkedserver 
  @server='PRODUCTION', 
  @provider='xxx.safesecureweb.com',
  @Username='myUsername', 
  @Password='myPassword'
  </code></pre>
  
  <p>What I'm thinking of doing is writing a bunch of insert statements like:</p>
  
  <pre><code>INSERT INTO Test.Table
  SELECT * FROM Production.Table
  </code></pre>