MSsubscriber_info (T-SQL)

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
password sysname Password for SQL Server Authentication
description nvarchar(255) Description of the Subscriber
security_mode int Implemented security mode:
0 = SQL Server Authentication
1 = Windows NT Authentication

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.