Tag: sp_scriptpublicationcustomprocs

Distribution agent failing with “procedure was called with an incorrect number of parameters”.

Sateesh Yele Microsoft SQL Server Support Transactional replication allows you to specify how data changes are propagated from the Publisher to Subscribers. For more information, please check this link. Specifying How Changes Are Propagated for Transactional Articles Recently, I worked on a case where the distribution agent failed with procedure was called with an incorrect
Read More »

How to manually synchronize replication subscriptions by using backup or restore

The Microsoft Knowledge Base contains the following article for setting up a SQL 2000 Subscriber using Backup/Restore.  Once the subscriber is restored sp_scriptpublicationcustomprocs is executed to create the subscriber Replication SPs. 320499 How to manually synchronize replication subscriptions by using backup or restore http://support.microsoft.com/default.aspx?scid=kb;EN-US;320499 These steps should be modified for SQL 2005/2008 which automatically creates
Read More »