Hi,

Check the following

a. Register the server using the named-pipes (client network library) and try using the replication wizard.

b.   ...

--Here is the basic query

select publisher_db,max(time),a.agent_id

from distribution..msmerge_history a, distribution..msmerge_agents b

where a.agent_id=b.id

group by publisher_db,a.agent_id

--For the above  agentid from the basic query, obtain the CURRENT_STATUS

--from distribution..msmerge_history table .

rangark.

If you want to insert an identity value outside the identity ranges available, reseed the identity range to the identity value where you want to generate and then  insert the...

One can write a simple SQL to get the status using the following tables from distribution database and call it in VB

MSMERGE_HISTORY & msmerge_agents .

The column runstatus will give you...

The steps for this are

1. Ensure the databases are in sync

2. Delete the subscritpion

3. Recreate the subcription excluding the table you don't need

4. Now setup the publication, no need to...

Adding new tables part of existing publication is pretty simple . Unfortunately there is no system sp which one could rely on to do this. You can use the EM...

Drop a table from the database

You need to stop the replication and remove the table from the publication and regenerate the snapshot

Modify a column to change or apply:

can be done...

Don't worry about indexes on rowguid. The problem may not be with rowguid.

It could be one or more of the foll situations

a) Identity column should be set Not for replication

b)...

Run the snapshot again, you may able to overcome this

rangarak

Hi Philip,

Thanks for your suggestion.

The only issue is the table is question is the most accessed table and with plenty of inserts/updates.  The trace file will be very huge for...

Many thanks for your inputs.

In case of any disconnection from the client during a process,we check for the connectivity and try to have normal logout  process. We poll constantly for...

Remember  to create the index at respective databases (Publiser and subscriber servers)

When you install SQL server you have an option to setup using a) SQL Authentication or b)SQL and Windows authentication.

Always setup using b so that you have best of both...

The problem happens when a transactions is rolled back on the table where you have the Identity column has the primary key. The identity value does not get resets. When...

Two things could be possible for this problem

a) Foreign keys should be set "Not for replication"

b) Some rows are inserted either at the publisher or subscriber. Since the row was...