title: sp_dropserver and sp_addserver not working
body: <p>I am using SQL Server Express 2008 R2 and I wanted to change the instance name from "machine name"\SQLEXPRESS2008R2 to just "machine name".  I ran:</p>
  
  <pre><code>sp_dropserver 'old_name'
  
  go
  
  sp_addserver 'new_name', 'local'
  
  go
  </code></pre>
  
  <p>Then restarted the SQL Service.  Now when I look at </p>
  
  <pre><code>Select @@SERVERNAME --this is correct
  </code></pre>
  
  <p>But this isn't correct?</p>
  
  <pre><code>Select serverproperty('ServerName') --This still shows old name
  </code></pre>
  
  <p>So when I try to connect to my instance via SSMS I still have to connect using the old instance name isntead of the new on I just applied? What am I doing wrong? Why is the new name not taking?</p>
  
  <p>Thanks,</p>
  
  <p>S</p>