NOT FOR REPLICATION usage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

maxzsim - 29 May 2006 02:16 GMT

Hi All ,

I read from BOL abt this NOT FOR REPLICATION is uses primarily for identity
values.

I have the following situation

I am creating a trigger that actually updates/insert records into tblA in
DB_A but this tblA is involved in replication to tblA in DB_B so should the
"NOT FOR REPLICATION" be used in the trigger ?

appreciate ur advice

tks & rdgs

Reply to this Message

Hilary Cotter - 29 May 2006 14:42 GMT

Yes, it should be used if

1) the table the trigger is writing to is not published.
2) you need the trigger to be enforced on the subscriber for DML originating
on the Subscriber from non-replication processes

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi All ,
>
[quoted text clipped - 12 lines]
>
> tks & rdgs

Reply to this Message

maxzsim - 31 May 2006 06:13 GMT

tk you

>Yes, it should be used if
>
[quoted text clipped - 7 lines]
>>
>> tks & rdgs

Reply to this Message