| title | Article Options for Transactional Replication | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/01/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | article | ||
| helpviewer_keywords |
|
||
| ms.assetid | 3469b185-0ea5-4690-a71c-717230d886b6 | ||
| caps.latest.revision | 30 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
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.