Alternative synchronization partners can be used in merge replication. Caveates: all computers must be using SQL 2000 and the subscriptions must be global (AFAIR). If you are using named Subscriptions,...

Ramesh,

indexes and constraints can be altered using sp_addscriptexec, to be run before the sp_repldropcolumn.

Rgds,

Paul Ibison, SQL MVP

AFAIK, in merge replication, there is no possibility of dropping the subscription on a per article basis, unlike in transactional and snapshot replication.

Almost all changes can be...

Are you replicating a stored procedure or UDF which has the 'IF UPDATE' statement in it?

Paul Ibison, SQL MVP

It all depends what is in your script. If it creates the distributor, adds a publication and adds a subscription, all you'll need to do is run the snapshot agent...

If the subscriber is an immediate updating one, basically there can't be any commands waiting as changes on the subscriber exist in a distributed transaction with the publisher, so I...

Hi Earl, I've looked on Jobserve.co.uk and the SQL DBA market seems good but to be honest I don't have time to contact loads of agencies yet (I'm involved in...

Dharmendra,

I'd recommend you to post your message in an entirely new thread in this forum. This'll mean that your post will get on the daily newsletter (assuming nobody posts afterwards) which...

If you can map a drive, and have access to files, then that's enough.

Make sure B can see the repldata share on A and post up any error message you see...

Funnily enough I have just completed an article on this that I'll be submitting to this site today. It's too big to post up, but this MS article gives some...

A few points:

From the server having SQL 2000 can you map a drive to a share (eg the repldata one) on the other server? If this is not possible, then...

I'm interested in what happens after the data is deleted at the subscriber? Does resynchronization need to happen?

Anyway, to solve the original issue, you could synchronize, then disable the...

As far as I understand filters have no effect.

This article may be of interest to you: http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;307356

Rgds,

Paul Ibison (SQL Server MVP)

Not in SQL Server 2000, assuming they are all part of the same publication. This is possible in SQL Server 2005, but in SQL 2000 the recommendation is to create...

Jay,

have a look in BOL for 'monitoring server performance, tools'.

The main ones for your purposes will probably be SQL Profiler and Windows Performance Monitor, but the above link will point...