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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-09 : 12:33:25
|
| Kavita writes "HI,I am using Microsoft SQL Server 2000 - 8.00.760 (Intel X86) on Windows NT 5.0 (Build 2195: Service Pack 4) My Problem is that I am not able to change the name of my Server.I Deleted the Server name using Sp_Dropserver 'Beb' Then I added new one with Sp_AddServerName 'Kavita'. I Stopped SQL Server and Restarted it.Then I registered 'Kavita' as my new registration.Again After few second when I am checking table sysservers from master database I am not getting 'Kavita' there and 'Beb' is still there . Is this because of my Old Service Pack ?Please guide me.Thanks Kavita" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-09 : 12:58:43
|
| What does SELECT @@SERVERNAME show?Tara |
 |
|
|
|
|
|
Not able to change the Server Name