title: How to switch server connection in SQL Server?
body: <p>I have a transaction that inserts into two different tables that are on two different servers. I want to do some insertions and then switch to another server and do some more insertions. How do I achieve this via SQL?</p>
  
  <p>I apologize if this is a duplicate but I could not find my answer via StackOverflow or Google. Thank you!</p>
  
  <p>I'm using SQL Server 2016 and Management Studio</p>