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 Edition
21 = Workgroup Edition
30 = Enterprise Edition (Evaluation Edition)
31 = Developer Edition
40 = Express Edition
|
See Also