Defining an Article

An article contains either data from a table in the database, one or more stored procedures in the database, or both table data and stored procedures.

Table Articles

A table article can be the entire table or a subset of columns or rows. For each table article, you can:

Specify the article name, article description, and destination table name.
Exclude rows and columns from those published (filtering).
Customize the synchronization schema script.

For merge replication, you can also:

Customize the data replication mechanism.
Specify a custom conflict resolver.

Important A table used in a snapshot or transactional publication can have a maximum of 255 columns and a maximum row size of 8,000 bytes. A table used in a merge publication can have a maximum of 246 columns and a maximum row size of 6,000 bytes.

Stored Procedure Articles

A stored procedure article can contain one or more stored procedure that exist in the database at the time the publication is created. For each stored procedure article, you can:

Choose the stored procedure to publish.
Specify whether to drop a stored procedure with the same name if it already exists at the Subscriber.
Specify when to replicate the execution of the stored procedure.

You can publish stored procedures as an article in a snapshot or transactional publication, but not in a merge publication.

To define an article (snapshot, transactional, or merge)

To define a snapshot or transactional article

To define a snapshot article

To define a transactional article

To define a merge article