@@ServerName not returning actual server name

[TheDrider]

We have a new machine, we'll call it JAK_NEWSERVER, with a default instance of 2000 installed on it. When calling @@ServerName, it properly returns JAK_NEWSERVER.

Now, the admin troupe has rename the server to just NEWSERVER. They like to make changes. This also renamed the SQL ServerName. I can connect to the server fine from several sources using the new server name, so that's not an issue.

The problem is that @@ServerName is still returning the old name with the JAK_ prefix. Any ideas why it's not returning the correct name, or where to fix it?

Thanks

 

[SQLDenis]

What does this return?

select SERVERPROPERTY ( 'MachineName' )

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[gmmastros]

Check out this site. It may help.

http://support.microsoft.com/kb/303774/en-us

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[mrdenny]

Do this.

exec sp_dropserver 'JAK_NEWSERVER'
go
exec sp_addserver 'NEWSERVER', local
go

Then restart SQL and you should be good to go.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[TheDrider]

Looks like it should work, thanks! I'll try it once they put the box back online...