SUMMARY: After changing computer name, then running sp_dropserver and sp_addserver to change name, OLD server name persists in @@SERVERNAME.
QUESTION: What problems can this cause, and what can I do to change this?
Thanks for any assistance.
STEPS:
Name of the computer running SQLExpress 2014 on Windows 7 had been changed. Unable to add new login in Management Studio because correct server name was not found.
Found Microsoft library article on passing new server name to SQLExpress using sp_dropserver and sp_addserver procedures.
Ran procedures through Query window in Management Studio but received syntax errors, and it appeared they did not run. @@SERVERNAME returned OLD machine name, both before and after attempting to run procedures.
Restarted Management Studio.
Now, it appears server name HAS been changed, as NEW-NAME is shown in login connection information.
HOWEVER, @@SERVERNAME is ...
Go to the complete details ...