Export (0) Print
Expand All
Expand Minimize

MSsubscriber_info

SQL Server 2000

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


Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft