A distribution procedure is created for each replicate article. The purpose of the distribution procedure is to:
Read the shadow table of the primary article that the replicate article subscribes to, and
Apply the transaction operations to the replicate database, using data read from the shadow tables.
The distribution procedure for a table applies insert, update, and delete statements to the replicate article proxy table.
The distribution procedure for a stored procedure executes remote procedure calls in the replicate database.
Distribution procedure names begin with the characters dp, followed by an incremented “odometer” value. For example, the name of the first distribution procedure created is dpa.