RemoveAlternatePublisher Method

SQL-DMO

SQL-DMO

RemoveAlternatePublisher Method

The RemoveAlternatePublisher method disables an alternate Publisher in the alternate Publishers list.

Applies To
MergePublication2 Object
Syntax

object.RemoveAlternatePublisher(
szAlternatePublisher ,
szAlternatePublicationDB ,
szAlternatePublication )

Parts

object

Expression that evaluates to an object in the Applies To list

szAlternatePublisher

String that specifies the name of the alternate Publisher

szAlternatePublicationDB

String that specifies the name of the publication database

szAlternatePublication

String that specifies the name of the publication

Prototype (C/C++)

HRESULT RemoveAlternatePublisher(
SQLDMO_LPCSTR pszAlternatePublisher,
SQLDMO_LPCSTR pszAlternatePublicationDB,
SQLDMO_LPCSTR pszAlternatePublication);

Remarks

Use the RemoveAlternatePublisher method to disable a server in the list of alternate Publishers to which pull subscriptions can synchronize. Subscribers run the EnumAlternatePublishers method to obtain a list of enabled alternate Publishers to which they can synchronize data changes.

Use the AddAlternatePublisher method to enable a server in the list of alternate Publishers to which subscriptions can synchronize.

Note  If an application calls RemoveAlternatePublisher on an instance of SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000" are returned.

See Also

AddAlternatePublisher Method

AllowSyncToAlternate Property

EnumAlternatePublishers Method