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 2005 Forums
 SQL Server Administration (2005)
 Rename Server (sp_addlinkedserver)

Author  Topic 

kappa02
Yak Posting Veteran

65 Posts

Posted - 2009-03-05 : 15:46:08
I would like to rename my server name from ServerA to ServerB
Can I do this by using sp_addlinkedserver? Instead of using the netdom command? In SQL 2000 you can do this with sp_addserver and then restarting the server.

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2009-03-05 : 16:00:51
see this http://blogs.technet.com/johnbaker/archive/2005/08/28/409917.aspx
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-03-05 : 16:03:39
sp_addlinkedserver can not be used for this. Use sp_addserver just like Books Online states for renaming servers.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -