title: How to select data of a table from another database in SQL Server?
body: <p>Suppose that I have a database which name is <code>testdb</code> in <strong>test server</strong>.
  I also have a database named <strong>proddb</strong> in <strong>prod</strong> server.</p>
  <p>Now I want to select data of a table of <strong>testdb</strong> database from <strong>proddb</strong> database.</p>
  <p>How can I do that in <strong><code>SQL Server</code></strong>?</p>
  <p>Also, I can do it using <strong>database link</strong> in <strong>oracle</strong>. But how can do that in <strong>SQL Server</strong>?</p>