title: How do I access Linked server Tables in sql server
body: <p>I have created a Linked server through LAN, </p>
  
  <pre><code>Linked server Name-[DELL-PC]
  </code></pre>
  
  <p>Here, I'm not able to run this query to select Values from Linked server</p>
  
  <pre><code>case :1
      select *From  [DELL-PC].[BTS_Server].[dbo].Assy_ProductionOrder_ParameterSetting
      select *From  [DELL-PC].[BTS_Server]..Assy_ProductionOrder_ParameterSetting
  </code></pre>
  
  <p>it says:</p>
  
  <blockquote>
    <p>"Invalid object name 'BTS_Server.dbo.Assy_ProductionOrder_ParameterSetting'."</p>
  </blockquote>
  
  <p>but if i use <code>openquery</code>, it is working smoothly</p>
  
  <pre><code>case :2
      select * 
      From openquery([DELL-PC],
      'Select *From [BTS_Server].[dbo].Assy_ProductionOrder_ParameterSetting ');
  </code></pre>
  
  <p>How do i access linked server Table like case 1 statements, kindly assist me.</p>