MSpublisher_databases (Transact-SQL)
Applies to: SQL Server
The MSpublisher_databases table contains one row for each Publisher/Publisher database pair serviced by the local Distributor. This table is stored in the distribution database.
Column name | Data type | Description |
---|---|---|
publisher_id | smallint | The ID of the Publisher. |
publisher_db | sysname | The name of the Publisher database. |
id | int | The ID of the row. |
publisher_engine_edition | int | The edition of the SQL Server Publisher, which can be one of the following: 10 = Personal Edition 11 = Desktop Engine (MSDE) 20 = Standard 21 = Workgroup 30 = Enterprise (Evaluation) 31 = Developer 40 = Express (Express cannot be a publisher. This value is present for completeness.) |