apply the fk's using the post snapshot command.

However, when I include DRI on my snapshot publications, I do get the DRI transfered. I am not sure what is happening on...

DTS is twice as fast as snapshot replication only if you have a single subscriber.

I would use bcp for this with a larger commit batch size. You will find that...

are there any informational messages in the event log from mssearch or mssci?

A population of 30,000,000 rows will take several days.

http://support.microsoft.com/default.aspx?scid=kb;en-us;320773

--

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

http://www.indexserverfaq.com/TextCopy.htm

http://www.indexserverfaq.com/SQLLoadADO.htm

use the replication activeX control for this.

--

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

http://www.indexserverfaq.com/TableNotEnabled.htm

what type of server are you replicating too?

MySQL?

--

Hilary Cotter

Looking for a book on SQL Server replication?

http://www.nwsu.com/0974973602.html

I'm confused by your question. Part of the reason is that this guy who sits beside me is hysterically laughing or crying all the time and I can barely hear...

It is entirely possible to store the binary format word doc into a text field, but you have to convert the document on a byte by byte basis to a...

I would advise against snapshot and log shipping as they are not real time. With log shipping and snapshot replication you users will have to go offline on the reporting...

There is a bug which you may be encountering. Can you provide me with the stack dump you will see in the error log?

--

Hilary Cotter

Looking for a SQL Server...

Be very careful about the log reader. You will be unable to issue sp_replcmds calls unless you issue an sp_replflush before. The reason is the old log reader agent still...

Connect to your distributor using Enterprise Manager. Go to Tools, Replication, Configure Publishers, Subscibers, and Distributors. Click the publishers tab. Is there a check mark to the left of the...

I would advise you to run a validation to the scope of your database consistency problem.

The I would also look at the conflict table(s) using the conflict viewer to...