Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSsubscriber_info (Transact-SQL)
Collapse the table of content
Expand the table of content

MSsubscriber_info (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

The MSsubscriber_info table contains one row for each Publisher/Subscriber pair that is being pushed subscriptions from the local Distributor. This table is stored in the distribution database.

Note   This system table has been deprecated and is being maintained to support previous versions of Microsoft SQL Server.

Column name

Data type

Description

publisher

sysname

The name of the Publisher.

subscriber

sysname

The name of the Subscriber.

type

tinyint

The subscriber type:

0 = SQL Server Subscriber.

1 = ODBC data source.

login

sysname

The login for SQL Server Authentication. Stored in encrypted format if Subscriber is added with SQL Server Authentication mode.

password

nvarchar(524)

The password for SQL Server Authentication. Stored in encrypted format if Subscriber is added with SQL Server Authentication mode.

description

nvarchar(255)

The description of the Subscriber.

security_mode

int

The implemented security mode:

0 = SQL Server Authentication.

1 = Microsoft Windows Authentication.

Community Additions

ADD
Show:
© 2015 Microsoft