Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

sp_configure Error

3 posts in Windows NT Last posting was on 2001-02-06 18:32:48.0Z
Gerardo A. Posted on 2001-02-06 17:16:55.0Z
From: "Gerardo A." <garroyo@nacion.co.cr>
Subject: sp_configure Error
Date: Tue, 6 Feb 2001 11:16:55 -0600
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <LvdkHMGkAHA.301@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 196.40.18.5
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1247
Article PK: 1088720

Hi,

when I execute the instruction:
sp_configure "start mail session", 1

I get the next error message:
10:55:55 Server: 16, 203: SIS_REPLICADO/sp_configure/433: The name
'S-SIS_REPLICADO_XP' is not a valid identifier.

Also, the select * from sysservers:

srvid srvstatus srvname srvnetname
srvclass srvsecmech
------ --------- ------------------------------ ----------------------------
---- -------- ------------------------------
0 8 SIS_REPLICADO SIS_REPLICADO
0
1 8 SYB_BACKUP S-SIS_REPLICADO_BS
2 0 S-SIS_REPLICADO_XP S-SIS_REPLICADO_XP


What's the problem? any idea, suggestion?

Thanks in advance!!


Bret Halford Posted on 2001-02-06 18:32:48.0Z
Message-ID: <3A804350.75ED1A95@sybase.com>
Date: Tue, 06 Feb 2001 11:32:48 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: sp_configure Error
References: <LvdkHMGkAHA.301@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 24
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1246
Article PK: 1088722

Hyphens are not allowed in identifiers (see chapter one of the TSQL Guide for
rules for identifiers).

-bret

"Gerardo A." wrote:

> Hi,
>
> when I execute the instruction:
> sp_configure "start mail session", 1
>
> I get the next error message:
> 10:55:55 Server: 16, 203: SIS_REPLICADO/sp_configure/433: The name
> 'S-SIS_REPLICADO_XP' is not a valid identifier.
>
> Also, the select * from sysservers:
>
> srvid srvstatus srvname srvnetname
> srvclass srvsecmech
> ------ --------- ------------------------------ ----------------------------
> ---- -------- ------------------------------
> 0 8 SIS_REPLICADO SIS_REPLICADO
> 0
> 1 8 SYB_BACKUP S-SIS_REPLICADO_BS
> 2 0 S-SIS_REPLICADO_XP S-SIS_REPLICADO_XP
>
> What's the problem? any idea, suggestion?
>
> Thanks in advance!!


Gerardo A. Posted on 2001-02-06 18:31:20.0Z
From: "Gerardo A." <garroyo@nacion.co.cr>
References: <LvdkHMGkAHA.301@forums.sybase.com> <3A804350.75ED1A95@sybase.com>
Subject: Re: sp_configure Error
Date: Tue, 6 Feb 2001 12:31:20 -0600
Lines: 47
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <Nyszu1GkAHA.199@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 196.40.18.5
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1245
Article PK: 1088712

Thanks Bret!!

Which is the apropiate procedure to fix this identifier? maybe update the
sysservers table?

Thanks again!

"Bret Halford" <bret@sybase.com> wrote in message
news:3A804350.75ED1A95@sybase.com...
> Hyphens are not allowed in identifiers (see chapter one of the TSQL Guide
for
> rules for identifiers).
>
> -bret
>
>
> "Gerardo A." wrote:
>
> > Hi,
> >
> > when I execute the instruction:
> > sp_configure "start mail session", 1
> >
> > I get the next error message:
> > 10:55:55 Server: 16, 203: SIS_REPLICADO/sp_configure/433: The name
> > 'S-SIS_REPLICADO_XP' is not a valid identifier.
> >
> > Also, the select * from sysservers:
> >
> > srvid srvstatus srvname srvnetname
> > srvclass srvsecmech
>
> ------ --------- ------------------------------ --------------------------
--
> > ---- -------- ------------------------------
> > 0 8 SIS_REPLICADO SIS_REPLICADO
> > 0
> > 1 8 SYB_BACKUP S-SIS_REPLICADO_BS
> > 2 0 S-SIS_REPLICADO_XP S-SIS_REPLICADO_XP
> >
> > What's the problem? any idea, suggestion?
> >
> > Thanks in advance!!
>