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 |
|
100s
Starting Member
1 Post |
 Posted - 2005-01-21 : 05:44:58
|
| How can I change the name of SQL 2k Server? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-01-21 : 05:50:14
|
quote:
Originally posted by 100s
How can I change the name of SQL 2k Server?
check BOL for:sp_dropserversp_addserverdon't forget to restart the sql services afterwards--------------------keeping it simple... |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-01-24 : 19:50:07
|
| Don't forget to update the sysjobs table either. (Why doesn't sp_addse......nevermind).UPDATE msdb..sysjobsSET originating_server = 'newservername'WHERE originating_server = 'oldservername'MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-01-25 : 05:03:41
|
quote:
Originally posted by derrickleggett
Don't forget to update the sysjobs table either. (Why doesn't sp_addse......nevermind).UPDATE msdb..sysjobsSET originating_server = 'newservername'WHERE originating_server = 'oldservername'MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA.
i dare you to continue that phrase, it seems the MeanOldDBA is not really mean afterall.--------------------keeping it simple... |
|
|
|
|
|
|
How can I change the name of SQL Server?