Solved

How to change @@servername?

Posted on 1998-07-10
2
1,531 Views
Last Modified: 2008-03-03
Hello,
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.
rgds.
alan
alanpong@hkstar.com
0
Comment
Question by:alanpong
2 Comments
 
LVL 1

Author Comment

by:alanpong
ID: 1091724
the server is mssql 6.5.
0
 
LVL 2

Accepted Solution

by:
odessa earned 50 total points
ID: 1091725
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
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL SERVER - Index skipped a number 2 25
Amazon RDS migrate to SQL Server 3 24
Run Stored Procedure uisng ADO 5 19
RESTORE MASTER DATABASE -- NOW 2 14
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question