title: SQL Server Insert into linked server
body: <p>In a procedure I control errors with <code>TRY</code> <code>CATCH</code>, but in an insert into linked server not runs for handling this errors, because try catch not run.</p>
  
  <p>How I can handling this errors?</p>
  
  <p>Example: </p>
  
  <pre><code>insert into linkedserver.database.dbo.table values ('value1','value2')
  </code></pre>
  
  <p>If the server isoffline I have error of connection of the <code>SQLCLI</code> and cannot control this error for insert in local when the linked server are offline for after when the server return to online status put the data in the remote server with another procedure.</p>
  
  <p>Thanks</p>
  
  <p>Jorge</p>