title: Why is using OPENQUERY on a local server bad?
body: <p>I'm writing a script that is supposed to run around a bunch of servers and select a bunch of data out of them, including the local server. The SQL needed to SELECT the data I need is pretty complicated, so I'm writing sort of an ad-hoc view, and using an OPENQUERY statement to get the data, so ultimately I end up looping over a statement like this:</p>
  
  <pre><code>exec('INSERT INTO tabl SELECT * FROM OPENQUERY(@Server, @AdHocView)')
  </code></pre>
  
  <p>However, I've heard that using OPENQUERY on the local server is frowned upon. Could someone elaborate as to why? </p>