This topic has not yet been rated - Rate this topic

TransSubscription.SubscriberCatalog Property

Gets or sets the catalog used when making a connection to the OLE DB provider for a non-SQL Server Subscriber.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
public string SubscriberCatalog { get; set; }

Property Value

Type: System.String
A String value that can be a maximum of 128 Unicode characters.

The SubscriberCatalog property should only be set for non-SQL Server Subscribers.

The value of SubscriberCatalog is passed as the DBPROP_INIT_CATALOG property to initialize the OLE DB provider.

The SubscriberCatalog property can only be retrieved by members of the sysadmin fixed server role, by members of the db_owner fixed database role, or by the user who created the subscription.

The SubscriberCatalog property can only be set by members of the sysadmin fixed server role or by members of the db_owner fixed database role.

Retrieving SubscriberCatalog is equivalent to executing sp_helpsubscription (Transact-SQL).

Setting SubscriberCatalog is equivalent to executing sp_addpushsubscription_agent (Transact-SQL) or sp_changesubscription (Transact-SQL).

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.