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.
| Author |
Topic |
|
vqd2697
Starting Member
2 Posts |
 Posted - 2007-11-16 : 20:53:48
|
| Do I have to do anything when hostname (servername) with SQL Server 2005 install was changed from OLDNAME to NEWNAME? If yes, what need to be done and syntax? I notice it under SYSSERVERS table still contain the OLDNAME.EX. TEST1\PROD01 was changed to TEST2\PROD01Thanks,Vu |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 01:11:10
|
| sp_dropserver TEST1\PROD01 sp_addserver TEST2\PROD01, localThen restart sql. |
 |
|
|
|
|
|
Rename hostname on Server 2005