MSpublisher_databases (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.)

See Also

Replication Tables (Transact-SQL)