title: SQL Server: is it possible to get data from another SQL server without setting linked server?
body: <p>I need to do the following query (for example):</p>
  
  <pre><code>SELECT c1.CustomerName FROM Customer as c1
  INNER JOIN [ExternalServer].[Database].[dbo].[Customer] as c2
  ON c2.RefId = c1.RefId
  </code></pre>
  
  <p>For some security reason my client doesn't allow me to create a linked server. The user under whom I execute this query has access to both tables. Is it possible to make it work without using linked server? Thanks. </p>