title: How to get the data from linked servers using queries
body: <p>I have created a <code>linkedserver</code> as <code>ravikiran-vm</code> which is the virtual machine in my desktop.</p>
  
  <p>Now I have a database called <code>kiran</code> which contains an <code>employ</code> table.<br>
  To retrieve <code>employ</code> data, I do the following:</p>
  
  <pre><code>select * from ravikiran-vm.kiran.employ
  </code></pre>
  
  <p>but it shows the error "Incorrect syntax near '-'."</p>
  
  <p>Can anyone help me, please?</p>
  
  <p>Thanks in advance.</p>
  
  <p>Thanks guys with ur support it working fine...
  Now i hav to schedule this as a new job.when i execute it as normal it shows o/p.
  but when i cinfigure the same query as sqlserver agent job it gives error and query not executing...Plz help me in this regard</p>
  
  <p>Thanks in advance</p>