The “NOT FOR REPLICATION” option in SQL Server Replication:

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

The NOT FOR REPLICATION option allows you to specify that the following database objects are

treated differently when a replication agent performs an operation:

* Foreign key constraints

The foreign key constraint is not enforced when a replication agent performs an insert, update, or

delete operation.

* Check constraints

The check constraint is not enforced when a replication agent performs an insert, update, or delete

operation.

* Identity columns

The identity column value is not incremented when a replication agent performs an insert

operation.

* Triggers

The trigger is not executed when a replication agent performs an insert, update, or delete

Get Oracle Certifications for all Exams
Free Online Exams.com