Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayMSpublisher_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 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.) |