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.