Probleme Sp_addserver
Sep 23, 1999
Hello sir,
I have a error in replication. my server name is like that "encpc-emf"
But trying to install replication, the following error "Replication cannot be
installed as @@Servername null".
I am running Windows NT with Service pack 4 and SQL Server 6.5 .
I do this commande
sp_dropserver encpc-emf
->Msg 170 Level 15, State 1
Line 1 Incorrect syntax near '-'.
I do this commande
sp_addserver encpc-emf
->Msg 18482, Level 14, State 1
Unable to connect to site 'ENCPC4' because " is not defined as a remote server at the site"
I don't understand what does this mean's?
Please advice me..
View 1 Replies
Sep 28, 1999
Hello sir,
Thank you for the quick response to my first posting. The problem with the replication is stil present.
serv1 (name)=anc20
serv2(name)=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 _ ø ñ ý 3 ' æ ú , 1 § ¯ ¬ « _
¨ x ö 0 1 2 3 4 5 6 7 8 9 A=a A=… A=* A=ƒ A=a Ž=„ ?=† ’=‘ B=b C
=c €=‡ D=d E=e E=Š ?=‚ E=ˆ E=‰ F=f G=g H=h I=i I=? I=¡ I=Œ I=‹ J
=j K=k L=l M=m N=n ¥=¤ O=o O=• O=¢ O=“ O=o ™=” O=o P=p Q=q R=r S
=s á T=t U=u U=— U=£ U=– š=? V=v W=w X=x Y=y Y=y ˜ Z=z D=d _=_
The execution of procedure sp_helpsort in serv2:
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 _ ø ñ ý 3 ' æ ú , 1 § ¯ ¬ « _
¨ x ö 0 1 2 3 4 5 6 7 8 9 A=a A=… A=* A=ƒ A=a Ž=„ ?=† ’=‘ B=b C
=c €=‡ D=d E=e E=Š ?=‚ E=ˆ E=‰ F=f G=g H=h I=i I=? I=¡ I=Œ I=‹ J
=j K=k L=l M=m N=n ¥=¤ O=o O=• O=¢ O=“ O=o ™=” O=o P=p Q=q R=r S
=s á T=t U=u U=— U=£ U=– š=? V=v W=w X=x Y=y Y=y ˜ Z=z D=d _=_
The execution of procedure sp_helplanguage in serv1 and serv2:
go
-----------------------------*/
No alternate languages are available.
us_english is always available, even though it is not in syslanguages.
again Thank you in advance , your help in this matter is greatly appreciated
Tezniti
View 1 Replies
View Related
Feb 3, 2004
Hi all
I am trying to configure a merge replication of publication in LAN
The whole Dynamic Filter snapshot runs well, all the data are pumped to the subscriber and all dri, trg etc. scripts are executed without problem. Then it launch a synchronization. Logically and usually there is no data to be merged. But here it start to replicate a lot of change. It's been 8hours it runs and I've got 600000 update.
I have verified the snapshot, the subcribers parameters.... and as usal there is no mistake or error. Nothing change on my Server (SQL 2000 SP3a running on W2K SP2 English).
All was running well before. Since one week the problem appears.
Any Idea ?
View 2 Replies
View Related
Jun 23, 2005
Hi guys
I was busy renaming my server and sp_dropserver worked but when it tried to execute sp_addserver it threw an error saying the server already exists. why did this happen and how do i fix it so that @@SERVERNAME is equal to the server name (at the moment it is null).
Thanks
Nick
View 1 Replies
View Related
Mar 21, 2001
Hi,
I have 2 SQL Server 6.5 Servers. The first one is Server1 and the second one is Server2. On Server1 I have a database called DB1 and on Server2 I have a database called DB2.
I open up ISQL_w on Server1 and go to DB1. I want to select rows from a Server2 DB2.(Table2).
So I used sp_addserver to add a row to the sysservers table on Server1. (I did a SELECT * from Sysservers on Server1 to make sure that a row had been added.)
Then from ISQL_w on Server1(DB1) I executed the following command: SELECT * FROM Server2..DB2.Table2..It did not work. I tried SELECT * FROM Server2.DB2.Table2..It did not work. I tried SELECT * FROM Server2..DB2.dbo.Table2..It did not work.
Please tell me how I can access rows from Table2 (Which exists on Server2(DB2) from ISQL_w of Server1 (DB1)..
Thankx
KP
View 1 Replies
View Related
Feb 19, 2004
When I run this in the QA
SELECT @@SERVERNAME
i get
MachineNameInstanceName
why don't these commands work ?
sp_dropserver 'MachineNameInstanceName'
sp_addserver 'MachineNameInstanceName,'local'
View 3 Replies
View Related
