How to change @@servername?
Posted on 1998-07-10
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?