triggers in replication

melvik · July 5th, 2007, 04:44 AM

hi all:
My app running fine & Im going to distribute d data using Merge Replication SQL Server 2000 (SP4).
My problem is with tables that have trigger on INSERT.
when its replicate tiggers again fire (I guess) & it makes Conflict for my replicated Data. so I guess i should stiop triggers in this step so I set this in my triggers to not fire in Repication but i still have problem do u have any idia?

Code:

    if sessionproperty('replication_agent') = 1 
        return

Always:),
Hovik Melkomian.

ashu_from_india · July 5th, 2007, 06:03 AM

hey...try these links

http://msdn2.microsoft.com/en-us/library/aa237102(SQL.80).aspx

http://support.microsoft.com/kb/148819

http://msdn2.microsoft.com/en-us/library/ms152529.aspx

SQLScott · July 5th, 2007, 07:51 AM

you can set triggers "NOT FOR REPLICATION" which will eleviate this problem.

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

melvik · July 11th, 2007, 01:44 AM

yes dear Scott, I completly forgot that, I set it for my IDENTITY & Constraints but forgot to do for triggers, tnx to remind. good point

Always:),
Hovik Melkomian.