Home / server / Questions / 68456
Accepted
David Hayes
Asked: 2009-09-25 08:20:00 +0800 CST

@@SERVERNAME is NULL

  • 772

How do you fix the issue when SELECT @@SERVERNAME returns null

Dave

PS: I just figured this out but it wasn't obvious... Answer to follow

sql-server

1 Answers

  1. Best Answer
    sp_dropserver 'OLDNAME'
sp_addServer 'NEWNAME', 'local'

    The 'local' part is important, it doesn't work without it ( I think it attempts to add the server as a remote linked server without it)

    • 5