Hi,

 

Look at merge agent profile. The default profile has query timeout of 300 seconds by default. You can create a new profile ant increase a query timeout there.

There is also...

Hi,

 

Be carefull.

There is a bug in MSSQL2000. 

If columns are dropped and added through sp_repldropcolumn and sp_repladdcolumn on existing merge replication, You will get non-convergence on new subscriber(s) if you add them...

Hi

You should also look at 'Backing Up and Restoring Replication Databases' in BOL.

Restore of a 'distribution' database is simple in merge replication (not in transactional)

 

Darius

FYI

 

We had a case about this with MS.

It's a problem (bug) in MSSQL2000. And it will not be fixed in this version of SQL. Confirmed by MS.

Try to avoid such a...