Hi there,



I am looking for information regarding creating trigger on the table.
Below is the detail



-we are using sql 2000 with merge replication.

-using default conflict viewer

-when we publish tables it create conflict table for all the table in
our database, suppose I have table call Jobs, after publishing this
table there is another table created called
"conflict_pulicationname_Jobs".

-when ever there is duplicate entry in jobs table the second entry go to
"conflict_pulicationname_Jobs" and we can view from conflict viewer.

-I would like to create trigger for insert so that when ever there is
new data inserted in this to "conflict_pulicationname_Jobs" table I
will get the email, so that I can quickly go to conflict viewer and
resolved the conflict.



My question is whether I can create trigger on this to
"conflict_pulicationname_Jobs" table or not, if yes should I have to
mention "not for replication " or this should be for replication also.



Your help and information will be appreciated.



Thanks.








MS Sql Server LazyDBA home page