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 |
|
hwoarang
Starting Member
14 Posts |
 Posted - 2008-10-17 : 05:39:33
|
| Hi, may i know how to change sql server name |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-17 : 05:49:14
|
| Name of first instance of sql server is the name of the windows-server-machine where it's installed.I don't believe that we can change it.Planning replaces chance by mistake |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-17 : 09:03:45
|
| Have you already changed server name? If you have , you can change SQL server name like this:Look for sp_dropserver and sp_addserver |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-10-17 : 10:01:06
|
| And if changing the server name, be aware that scheduled jobs may not run because the originating_server may be different than the new server name. If S2K, you can update the column on table msdb..sysjobs to reflect the new server name (I'm sure there is comething comparable in S2K5).Terry |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-17 : 10:22:05
|
| If SQL 2005,Read this for jobs:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98114 |
|
|
|
|
|
|
change sql server name