Distribution databases contain the following tables dedicated to replication:
| Table | Description |
|---|---|
| MSjob_commands | Contains one entry for each command associated with a transaction in the MSjobs table. One transaction can contain many commands. |
| MSjob_subscriptions | Associates a subscriber with a particular article. (This is actually subscriber-side information that is maintained in the distribution database.) |
| MSjobs | Contains the actual transactions. There is one entry for every transaction stored in the distribution database. |
| MSsubscriber_info | Contains information used by SQL Executive for passing jobs. |
| MSsubscriber_jobs | Associates each subscriber with the command that subscriber needs to receive. |
| MSsubscriber_status | Contains status information for the individual batches of transactions sent to subscribers. |
For more information about these tables, see the Microsoft SQL Server Transact-SQL Reference.