title: How to update a linked server connection string?
body: <p>I'm using below statement for addling a linked server:</p>
  
  <pre><code>EXEC sp_addlinkedserver
  @server = 'north',
  @srvproduct = '',
  @provider = 'MSDASQL',
  @provstr = 'DRIVER={SQL Server};SERVER=192.168.100.147;UID=sa;PWD=xxxx;'
  </code></pre>
  
  <p>Now I want to update the linked server connection string, for example the server name and etc.
  Is there any statement to do it?</p>