Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Snapshot replication Expand / Collapse
Author
Message
Posted Monday, October 18, 2010 2:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 28, 2012 12:14 AM
Points: 163, Visits: 411
Hi All,

I have a problem in Replication (Snapshot replication)

I have two servers . 'A' server( sql 2000 Ver) another is 'B' server (sql 2005 Ver)
'A' server is is publisher. B is local server subscriber.There is snapshot replication from A to B for one table.
Data is replicating from 'A' to 'B'.
In Server 'B', we have a table tbl_main this table is getting data from server 'A' table tbl_main.
I have a trigger (ins,upd,del) trigger on tbl_main in 'B' server . But this trigger is not firing when replication agent ins/upd/del record on the table.Pls tell me where i am doing the mistake? What is the solution?

Thanks







Ramaa
Post #1006044
Posted Wednesday, October 20, 2010 4:28 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:19 AM
Points: 1,101, Visits: 5,271
Snapshot replication get does not ins/upd/del individual rows. It does bcp. By default bcp does not fire triggers.
Post #1007585
Posted Wednesday, October 20, 2010 7:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 28, 2012 12:14 AM
Points: 163, Visits: 411
Thank you Suresh for your info.




Ramaa
Post #1007691
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse