Hi,

Thanks for your valuable answer.

Thanks in advance

Ram.

Yes,it is possible to replicate the column changes.

Right click on Publisher -->click on properties

In property window,choose the Subscription option then make Replicate schema changes -->True

Hi,

Can you check the network configuration in SQLSERVER surface area configuration whether all the services is having the remote connection permission or not.

Regards,

ram

Hi,

Try this,Stop the synchronization process and then change the articles in Publisher database.

I hope this will solve your problem

Thanks for your valuable information Philip.

Hi Philip,

Thanks for your hints,Here after i wll ask this kind questions in General area

Thanks,

Ram

Hi,

Try this! First remove the article from the publisher and add the primary key to the table,

Then again publish the modified article in to the publisher database.

After...

Hi GermanDBA,

I have gone thru your scripts,can you explain the scripts?

Thanx in advance,

😛

Scenario 1:If the Log reader is slow

Scenario2 :If the Transaction taking long time from Distributor to Subscriber

Thanx in advance 🙂

Can you please give the solution for the 2 scenarios?

Thanx in advance:)

Can you reinstall the SQLSERVER 2005 in the Same Environment,it may be some installation issues.