MSsubscriber_info (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

MSsubscriber_info (Transact-SQL)

 

Applies To: SQL Server

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 nameData typeDescription
publishersysnameThe name of the Publisher.
subscribersysnameThe name of the Subscriber.
typetinyintThe subscriber type:

 0 = SQL Server Subscriber.

 1 = ODBC data source.
loginsysnameThe login for SQL Server Authentication. Stored in encrypted format if Subscriber is added with SQL Server Authentication mode.
passwordnvarchar(524)The password for SQL Server Authentication. Stored in encrypted format if Subscriber is added with SQL Server Authentication mode.
descriptionnvarchar(255)The description of the Subscriber.
security_modeintThe implemented security mode:

 0 = SQL Server Authentication.

 1 = Microsoft Windows Authentication.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft