MSpublisher_databases (Transact-SQL)
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.) |