sql server replication: Merge Replication: Import Data -- sql server replication

Merge Replication: Import Data

Javed Iqbal
12/28/2005 4:11:42 PM

sql server replication:

Hi,

I have MERGE setup between SERVER A (Publisher)---- SERVER B (Subscriber).

in a table on SERVER A i am importing data from an excel sheet say 100
records. But these records are not reflecting on SERVER B even after merge
agent runs several time.

What would be be possible cause?

Thanks in advance.

Regards
Javed

Re: Merge Replication: Import Data

Hilary Cotter
12/28/2005 10:06:38 PM

When you use DTS by default triggers are not fired; in the options tab of
Transform Data Task Properties uncheck the Use Fast Load option to have your
triggers fired. You need to issue a sp_addtabletocontents 'tableName' to
replicate its contents.

--
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

[quoted text, click to view]