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_addserver

3 posts in Windows NT Last posting was on 2001-01-09 10:40:00.0Z
Jim Herrick Posted on 2001-01-05 19:00:36.0Z
From: "Jim Herrick" <jim@herrick.net>
Subject: sp_addserver
Date: Fri, 5 Jan 2001 13:00:36 -0600
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <GCXC8w0dAHA.47@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: achievehealthcare.com 12.2.55.2
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1351
Article PK: 1088817

My question pertains to the SP_ADDSERVER proc and its effect on Sybase
server processes. I currently have 5 Sybase 11.9.2 server processes on 4 NT
servers and would like to ensure I'm able to monitor / control them from any
point on the network using Sybase Open Client.

Basically, I'm wondering about the difference between the following
statements:

SP_ADDSERVER servername, local
SP_ADDSERVER servername, ASEnterprise

I'm also wondering about and how it would affect the use of SP_REMOTESQL
with CIS enabled.

Thanks for your time!

Jim


Lazar Posted on 2001-01-09 10:40:00.0Z
From: Lazar
Date: Tue, 9 Jan 2001 05:40:00 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: sp_addserver
Message-ID: <4F9B4107858E367B003A97FA852569CF.0078591B852569CD@webforums>
References: <GCXC8w0dAHA.47@forums.sybase.com>
Lines: 2
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1339
Article PK: 1088805

SP_ADDSERVER servername, ASEnterprise = only for Remote Connect


Gordon Posted on 2001-01-08 20:29:05.0Z
Message-ID: <3A5A2310.DC01AA3B@sybase.com>
Date: Mon, 08 Jan 2001 13:29:05 -0700
From: Gordon <gsams@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Jim Herrick <jim@herrick.net>
Subject: Re: sp_addserver
References: <GCXC8w0dAHA.47@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 29
NNTP-Posting-Host: gsams-pc2.sybase.com 157.133.215.54
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1341
Article PK: 1088808

Jim,

The big difference is of course that the first statement defines servername as a
local server. The second implies CIS functionality is desired, defines
servername as a remote server with a server class ASEnterprise. sp_remotesql, as
the name implies, can be utilized via CIS when the server is remote, and not
when it's local though I believe some customers are using it on the local server
by having a second definition of that server as a remote server.

Gordon Sams
Sybase Omni Eng.

Jim Herrick wrote:

> My question pertains to the SP_ADDSERVER proc and its effect on Sybase
> server processes. I currently have 5 Sybase 11.9.2 server processes on 4 NT
> servers and would like to ensure I'm able to monitor / control them from any
> point on the network using Sybase Open Client.
>
> Basically, I'm wondering about the difference between the following
> statements:
>
> SP_ADDSERVER servername, local
> SP_ADDSERVER servername, ASEnterprise
>
> I'm also wondering about and how it would affect the use of SP_REMOTESQL
> with CIS enabled.
>
> Thanks for your time!
>
> Jim