Hello sir,

Thank you eric for the quick response to my first posting. The problem with the replication is stil present. serv1=anc20 serv2=anc15-def when i execute this commande sp_addserver serv2 in serv1, i receive this message: go -----------------------------*/ Msg 170, Level 15, State 1 Line 1: Incorrect syntax near '-'. when i execute this commande sp_dropserver serv1 in serv2, i receive this message: go -----------------------------*/ Msg 15190, Level 16, State 1 There are still remote logins for the server 'anc20'. the execution of the procedure sp_helpsort in serv1: go -----------------------------*/ Sort Order Description ------------------------------------------------------------------ Character Set = 1, iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit character set. Sort Order = 52, nocase Case-insensitive dictionary sort order for use with several We stern-European languages including English, French, and German . Uses the ISO 8859-1 character set. Characters, in Order ------------------------------------------------------------------ ! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~  -     ]  " c & . * - r _ x q } 3 ' f  z , 1 ' / , + _ ( x v 0 1 2 3 4 5 6 7 8 9 A=a A= A= A= A=a = = = B=b C =c

-- Anonymous, September 28, 1999

Answers

Tezniti,

Your first error, Msg 170, is caused by the fact that 'anc15-def' is an invalid server name. (It has the - character.) You can deal with this problem by following the instructions in the SQL Server Books Online article titled, "Replication and Invalid SQL Server Names".

Your second error, Msg 15190, is caused by remote logins for server 'anc20'. You may deal with this by issuing the command:

sp_dropserver anc20, droplogins

This will drop the remote logins for anc20 and then drop the anc20 server.

Hope this helps,

Eric

-- Anonymous, September 28, 1999