MSsubscriber_info

Transact-SQL Reference

Transact-SQL Reference

MSsubscriber_info

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.

Column name Data type Description
publisher sysname Name of the Publisher.
subscriber sysname Name of the Subscriber.
type tinyint Subscriber type:

0 = Microsoft® SQL Server™ Subscriber
1 = ODBC data source

login sysname Login for SQL Server Authentication. Stored in encrypted format if Subscriber is added with SQL Server Authentication mode.
password nvarchar(524) Password for SQL Server Authentication. Stored in encrypted format if Subscriber is added with SQL Server Authentication mode.
description nvarchar(255) Description of the Subscriber.
security_mode int Implemented security mode:

0 = SQL Server Authentication
1 = Windows Authentication