Article Options for Transactional Replication
Applies To: SQL Server 2016
There are a number of options for articles in transactional publications. With transactional replication, you can do the following:
Specify how changes are propagated from the Publisher to Subscribers. For more information, see Specify How Changes Are Propagated for Transactional Articles.
Specify that the execution of a stored procedure be replicated. This is useful in replicating the results of maintenance-oriented stored procedures that affect large amounts of data. For more information, see Publishing Stored Procedure Execution in Transactional Replication.
Specify schema options, such as whether constraints and triggers are copied to the Subscriber. For more information, see Specify Schema Options.
Use row filters and column filters. Filtering table articles enables you to create partitions of data to be published. For more information, see Filter Published Data.