Could not find stored procedure 'sp_MSin_<TableName>'

Hi,
Just completed the transactional replication and when tried to test the
changes made in the publisher data it (Distribution Agent) failed with the
following error:
Could not find stored procedure 'sp_MSupd_ACCOUNT'.
(Source: PARISDB2 (Data source); Error number: 2812)
Checked the sysobjects and all these procedures (sp_MSins, sp_MSupd etc) are
present in the database.
Current Configuration is: 1 Publisher, 1 Subscriber, Distributor database is
on the Publisher server, SQLServer 2000 (SP4), Windows 2003)
Please help me out....need to know the reason and the solution
Thanks & Regards
Sangra
Hi Sangra
This problem will happen when the snapshot schema is not applied on the
subscriber.
You can generate the scripts manually using the following procedure
exec sp_scriptinsproc 'articleid'
exec sp_scriptdelproc 'articleid'
exec sp_scriptmappedupdproc 'articleid'
Apply this script on the subscriber.
For getting the articleid check sysarticles table.
P. Srinivasan MCDBA
Consultant
C-13/1,GF,Tulip Garden, Ardee City,
Sector-52,
Gurgaon-122003
India
Mobile:+91-9810321551
"Sangra" <Sangra@.discussions.microsoft.com> wrote in message
news:1A700079-F991-4D00-82A6-756AF23CC16E@.microsoft.com...
> Hi,
> Just completed the transactional replication and when tried to test the
> changes made in the publisher data it (Distribution Agent) failed with the
> following error:
> Could not find stored procedure 'sp_MSupd_ACCOUNT'.
> (Source: PARISDB2 (Data source); Error number: 2812)
> Checked the sysobjects and all these procedures (sp_MSins, sp_MSupd etc)
> are
> present in the database.
> Current Configuration is: 1 Publisher, 1 Subscriber, Distributor database
> is
> on the Publisher server, SQLServer 2000 (SP4), Windows 2003)
> Please help me out....need to know the reason and the solution
> Thanks & Regards
> Sangra