My sys admin wants to change the name of the server that my sybase
server resides on.

What , if any, would be the consequences of this?

Praim Sankar
psankar (AT) ibc (DOT) ca

Praim Sankar wrote:
Generally speaking there are no problems with changing the name assuming,
of course, that you change the name *everywhere* it is referenced ...

.... all interfaces files
.... all config and RUNSERVER files
.... all master..sysservers entries (including @@servername for the server
itself)
.... all references in stored procs, triggers, referential integrity
constraints, shell scripts, etc.
.... all Replication Server objects that reference said server (eg, config
files, repdefs, subs, connections, etc.)

I'm probably leaving out a few other locations ... but you'll find them
soon enough after a name change, eh?!?! ;-)

--
Mark A. Parsons

Iron Horse, Inc.
iron_horse (AT) NOSPAM (DOT) compuserve.com

On Tue, 18 May 2004 17:42:28 +0000, Mark A. Parsons wrote:

Actually the files/locations that you need to change depend on whether you
change the name of the Sybase instance (i.e. the logical server name in
teh interfaces file), or the host name.

My reading of the OP's question is that it's the server name (host name)
that is changing - if that is correct and the Sybase instance stays the
same then only the interfaces file needs to be changed (assuming that the
host name is used there, and not the IP address.)

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html

Michael Peppler wrote:
Yeah, it would appear that I misread the post.

Thanks for the catch!

--
Mark A. Parsons

Iron Horse, Inc.
iron_horse (AT) NOSPAM (DOT) compuserve.com