All servers participating in replication keep some replication-related data in the sysservers and sysdatabases tables in the master database.
| Table | Description |
|---|---|
| sysservers | Used by both the publication and subscription servers. The srvstatus column has status bits set for RPC, PUBLISH, SUBSCRIBE, and DISTRIBUTE. A publication server uses all four options to register the servers with which it participates in replication. A subscription server uses only the RPC option to register the publication servers that it authorizes to send it publications. The options can be reviewed by running sp_helpserver and viewing the status column. |
| sysdatabases | Used by publication and subscription servers. Setting a status bit permits a database to publish. On the subscription server, sets a status bit allowing a database to subscribe, and aliases the repl_publisher login ID to DBO. |
For more information about these tables, see the Microsoft SQL Server Transact-SQL Reference.