Solved

How to change @@servername?

Posted on 1998-07-10
2
1,536 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

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…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

756 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