Thanks for your reply Andy,

I tried that but after stopping the session it wouldn't start a new session anymore. Also resetting the logfile had no effect.

I finally solved it by...

SELECT col1,col2 from table1 (index=0) -- Using no index

where col1 = ....

For mor info see BOL on Index Hints

I've seen this kind of error before. It can be caused by several reasons, but best thing to fix it is remove replication including the distributor role first and then...

Are they using SET IMPLICIT_TRANSACTION ON ??? This could explain that so much has been rolled back.

See BOL: Transactions that are automatically opened as the result of this setting...

Since when is it possible to post comment on QOD's for the following day ????

Are you sure theproblem appears when you synchronize the subscription ?

Sounds to me more like the second subscritpion is trying to initialize.

By default on initilization the tables are...

Sorry, I don't have a solution but I can confirm that this should not happen I ran merge replication over ISDN line myself with much more updates and I've never...

Why don't you just change the replication triggers on s2 to only fire for inserts and updates, but not for deletes. This way a delete won't be recorded as a...

How large is your DB. What kind of connection lies between the two servers ?

With larger tables over slower connections very often the reason for this message is a timeout....

As far as I know there are 2 possibilities. Either join the MS Beta tester group at http://windowsbeta.microsoft.com  or if you have a MSDN subscription you can download...

The resource kit for SQL2005 Beta2 contains a tool called databasepopulator. I think it will also work for SQL2K. Another option, though it's not free would be Quest Software (http://www.quest.com),...

You can add columns without removing the replication by using the sp_repladdcolum stored procedure. Check BOL for the full syntax.

If you need to stop replication anyhow you have the option...

I agree with Peter that most 3rd party tools are faster and offer extra features. Also most of them create smaller backups than zipping a "standard" backup manually, though this...

Hi Dave

I'm not totally sure but you need at least db_ddladmin, db_datareader and db_datawriter. The last two are obvious and ddladmin is needed during initialization because the tables on the subscriber...

Hi Iain

the most obvious thing would be creating a performance alert on the counter "Merge conflicts/sec". But from own experience I can tell you it won't work.

My solution was running...