title: Why does SQL Server @@SERVERNAME return my old machine name?
body: <p>I just stumbled across an issue in my SQL Server 2008 R2 - When I call <code>@@SERVERNAME</code>, it's returning my OLD computer's machine name, rather than the current one. Why is this? And how can I fix it? SQL Server somehow is remembering the old machine name.</p>