Could not find stored procedure 'sp_MSin

Could not find stored procedure 'sp_MSin_<TableName>'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sangra - 29 Mar 2006 14:27 GMT

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

Reply to this Message

Paramasivam Srinivasan - 30 Mar 2006 05:24 GMT

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.

Signature

P. Srinivasan MCDBA
Consultant
C-13/1,GF,Tulip Garden, Ardee City,
Sector-52,
Gurgaon-122003
India
Mobile:+91-9810321551

> Hi,
>
[quoted text clipped - 18 lines]
> Thanks & Regards
> Sangra

Reply to this Message