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 - 2003-09-23 : 08:09:18
|
| Beginner writes "Can I rename the SQL Server 2000 to a name different from my machine name?I tried the following snippetsp_dropserver <old_name>gosp_addserver <new_name>goBut it doesn't seem to work" |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-09-23 : 08:55:30
|
| Are you getting any error messages ?Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2003-09-23 : 09:22:05
|
| Default instance of SQL2k always carries the same name as the machine that it is installed on. A named instance is referenced by machine_name\instance_name |
|
|
|
|
|
|
Renaming SQL Server 2000