Share via


MSsubscriber_info (Transact-SQL)

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

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance