Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 chaning name of registered sql properties

Author  Topic 

Ex
Posting Yak Master

166 Posts

Posted - 2005-04-21 : 21:49:18
hey all.

i am tinkering with setting up replication but at the moment my registered sql name is local :(

i want to change this to the actual server name cause replication wont work with name local.

is there any way to do this without deleting the registration and reattaching it?

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-04-22 : 01:05:47
check out


sp_dropserver,
sp_addserver

to make life more easy, match the sql server name to the machine name
and don't forget to restart the sql services after changing the name

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -