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 nameData typeDescription
publisher_idsmallintThe ID of the Publisher.
publisher_dbsysnameThe name of the Publisher database.
idintThe ID of the row.
publisher_engine_editionintThe 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.)

Replication Tables (Transact-SQL)

Community Additions