MSsubscriber_info (Transact-SQL)
Applies to:
SQL Server
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)
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για