MSsubscriber_info (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

Definition

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.

See Also

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