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 Edition

21 = Workgroup Edition

30 = Enterprise Edition (Evaluation Edition)

31 = Developer Edition

40 = Express Edition

See Also

Concepts

Replication Tables (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance