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
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..
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
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'
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