Very Computer

by JJ » Sat, 11 Dec 1999 04:00:00

Hello

Does anyone know how to rename SQL Server if the NT Server name was
changed

TIA

Jason

by **Mary Bra** » Sat, 11 Dec 1999 04:00:00

In version 7 you run SQL setup and choose the upgrade option. This renames
the SQL Server. This is fine unless you have replication involved - Itzik
has a big procedure if this is the case :-) I'm sure he will insert it
<here> :-)

--
Mary Bray
MCP, MCT, MCSD, MCDBA, MCSE
Xyconyx Pty Ltd - ACN 083 079 323

> Hello

> Does anyone know how to rename SQL Server if the NT Server name was
> changed

> TIA

> Jason

by **Steve Dunca** » Sat, 11 Dec 1999 04:00:00

On 6.5 execute the following
master..sp_addserver 'new_name',LOCAL
then cycle the server. This will change the server's name. The server
name is stored in the table master..sysservers in the row with srvid =
0.
Steve Duncan

> Hello

> Does anyone know how to rename SQL Server if the NT Server name was
> changed

> TIA

> Jason

by JJ » Sat, 11 Dec 1999 04:00:00

Thankyou!!

> Hello

> Does anyone know how to rename SQL Server if the NT Server name was
> changed

> TIA

> Jason

Very Computer

Renaming Server

Renaming Server

Renaming Server

Renaming Server

Renaming Server