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 |
|
aiken
Aged Yak Warrior
525 Posts |
 Posted - 2002-01-15 : 14:00:54
|
| Ok, if you've been reading this forum for a while you know that I've been fighting with replication on a production server for over a month. Typical problem is that replication gets partly set up, and refuses to be partially removed. Previous topics: http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=11477 and http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=10933Well, I just discovered something strange. Maybe I'm just clueless and the function is no longer supported on SQL2K. But how about this:SELECT @@SERVERNAMENULLCan that be right? sp_helpserver looks right, with the netbios name of the server for both "name" and "network_name".Any ideas?Thanks-b |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-15 : 14:09:25
|
| Look in your errorlog, about 20 or so lines from the top, it will tell you the servername it is starting as. An easy way to fix it is:sp_dropserver NULLgosp_addserver 'correctname', localHTH-Chad |
 |
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2002-01-15 : 16:07:37
|
| Well, in the log it shows the correct server name for "Server name is...".sp_helpserver doesn't have a NULL entry.sp_dropserver NULL yeilds "The server (null) does not exist."Argh... any other ideas?Thanks-b |
|
|
|
PiecesOfEight
Posting Yak Master
200 Posts |
Posted - 2002-01-15 : 17:52:28
|
| Did you try running the add w/o doing the drop first? |
|
|
|
DavidD
Yak Posting Veteran
73 Posts |
Posted - 2002-01-15 : 18:36:30
|
| Did you install SQL Server from an image? We had a similar problem on an imaged laptop once. No real solution except re-installing. |
|
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2002-01-17 : 15:01:55
|
| No, this was an install from a CD. A recent one, too, as I did a complete reinstall hoping it would fix replication. No luck on that front.Doing the sp_addserver results in a "server sa111 already exists" (since it does appear in sp_helpserver). I'll try dropping that local server and re-adding it, I guess.Craziness. Does replication ever "just work" from the get-go?Cheers-b |
|
|
|
|
|
|
|
|
Replication Hell Continues: @@SERVERNAME=NULL