title: Creating a Linked Server and Database Alias
body: <p>I have two servers Server1 and Server2</p>
  
  <p>On both servers i have a Database called QAI</p>
  
  <p>is there a way that i can create a linked server with an alias from Server2 to Server1 but instead of 
  Server1.QAI.dbo.tbBlah</p>
  
  <p>Have it aliased as 
  QAI.dbo.tbBlah</p>
  
  <p>This is needed due to the QAI DB on server2 failing and needing to fall back to the Server1 instance while it is fixed</p>
  
  <p>Thanks</p>