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