title: Getting Wrong Server Name
body: <p><img src="https://i.stack.imgur.com/r4vyL.png" alt="enter image description here">I am executing a query from which i want to get all server name installed on a system<br>
  So I did it with this query  </p>
  
  <pre><code>select srvname  from sysservers    
  </code></pre>
  
  <p>It gives me server names but it is not the correct server name it gives me srvname  </p>
  
  <p><code>WIN-1BKHGVK7J3A\SQLSERVER2008R2</code>  </p>
  
  <p>but this is not my server name also i tried to do it from another way by this query   </p>
  
  <pre><code>Select @@Servername   
  </code></pre>
  
  <p>it also gives above wrong server name <code>WIN-1BKHGVK7J3A\SQLSERVER2008R2</code> </p>
  
  <p>But when i did it with this query  </p>
  
  <pre><code>SELECT SERVERPROPERTY ('ServerName')  
  </code></pre>
  
  <p>it gives correct server name which is <code>AIS-OCTACORE\SQLserver2008r2</code><br>
  but limitation with this is it only gives current server name and i want to get all server name installed  on a system<br>
  can you please tell why i'm getting wrong servername??<br>
  Also how could i get all server names</p>