How to change @@servername?

Something must be done by me so that there are
two entries in master.dbo.sysservers, they are :
srvid=0, srvname = nt1 ......
srvid=1, srvname = mynt ......

Also, i found host_name() = mynt but @@servername = nt1.
Now, i want to do replication.  While creating 'distribution' database, it comlain , nt1 cannot be found.

Should i just modify master.dbo.sysservers directly?
Does srvid = 0  mean it is @@servername?

Many thanks.
Who is Participating?
odessaConnect With a Mentor Commented:
Easy and simple if you want to change the name of your SQL server
execute system SP sp_addserver server_name [, LOCAL]
where server_name is the name you want to be and LOCAL stands for that to change your local server name. you must restart server for changing
alanpongAuthor Commented:
the server is mssql 6.5.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.