Could not find stored procedure 'sp_MSupd_xxxxxx'

I created a pull subscription to pull information from a production
database. When I started the subscription, the error "Could not find stored
procedure 'sp_MSupd_tablename'" showed.
I deleted the subscription in the subscriber and drop the distribution by
running the "Disable Publishing and Distribution Wizard" in the distributor.
Then, I recreated both the distribution and subscription from the very
beginning once again. However, the same error still showed.
I'd be grateful is anybody can help.
Thanks in advance!
KM
If you have used @.sync_type = None in sp_addsubscription or in the
subscription wizard, 'Initialize subscription' page, you select 'no, the
subscriber already has the schema and data' you may get this error. The
system tables for replication will be created on the subscriber in either
case but you'll need to manually create the stored procedures on the
subscriber if you use this option otherwise you'll have the above error when
you change a row on the publisher. Use sp_scriptpublicationcustomprocs
(assuming you have >= sp1) to create a script which creates the procedures
and run this script on the subscriber.
HTH,
Paul Ibison
"krygim" <krygim@.hotmail.com> wrote in message
news:ewJovUqhEHA.1356@.TK2MSFTNGP09.phx.gbl...
> I created a pull subscription to pull information from a production
> database. When I started the subscription, the error "Could not find
stored
> procedure 'sp_MSupd_tablename'" showed.
>
> I deleted the subscription in the subscriber and drop the distribution by
> running the "Disable Publishing and Distribution Wizard" in the
distributor.
> Then, I recreated both the distribution and subscription from the very
> beginning once again. However, the same error still showed.
>
> I'd be grateful is anybody can help.
>
>
> Thanks in advance!
>
> KM
>
|||Hi Paul,
Thanks a lot for your information. However, I was not able to find
sp_scriptpublicationcustomprocs in BOL. Could you show me how to use of the
procedure?
Thanks in advance.
KM
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:e4pQoWrhEHA.1184@.TK2MSFTNGP12.phx.gbl...
> If you have used @.sync_type = None in sp_addsubscription or in the
> subscription wizard, 'Initialize subscription' page, you select 'no, the
> subscriber already has the schema and data' you may get this error. The
> system tables for replication will be created on the subscriber in either
> case but you'll need to manually create the stored procedures on the
> subscriber if you use this option otherwise you'll have the above error
when[vbcol=seagreen]
> you change a row on the publisher. Use sp_scriptpublicationcustomprocs
> (assuming you have >= sp1) to create a script which creates the procedures
> and run this script on the subscriber.
> HTH,
> Paul Ibison
>
> "krygim" <krygim@.hotmail.com> wrote in message
> news:ewJovUqhEHA.1356@.TK2MSFTNGP09.phx.gbl...
> stored
by
> distributor.
>
|||This scenario may not be exactly yours, but you'll get the
idea:
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;320499

>--Original Message--
>Hi Paul,
>Thanks a lot for your information. However, I was not
able to find
>sp_scriptpublicationcustomprocs in BOL. Could you show me
how to use of the[vbcol=seagreen]
>procedure?
>Thanks in advance.
>KM
>
>"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
>news:e4pQoWrhEHA.1184@.TK2MSFTNGP12.phx.gbl...
sp_addsubscription or in the[vbcol=seagreen]
you select 'no, the[vbcol=seagreen]
this error. The[vbcol=seagreen]
subscriber in either[vbcol=seagreen]
procedures on the[vbcol=seagreen]
the above error[vbcol=seagreen]
>when
sp_scriptpublicationcustomprocs[vbcol=seagreen]
creates the procedures[vbcol=seagreen]
from a production[vbcol=seagreen]
error "Could not find[vbcol=seagreen]
the distribution[vbcol=seagreen]
>by
Wizard" in the[vbcol=seagreen]
subscription from the very[vbcol=seagreen]
showed.
>
>.
>
|||Thanks
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2c3f01c486c2$b82bc470$a301280a@.phx.gbl...[vbcol=seagreen]
> This scenario may not be exactly yours, but you'll get the
> idea:
> http://support.microsoft.com/default.aspx?scid=kb;EN-
> US;320499
>
> able to find
> how to use of the
> sp_addsubscription or in the
> you select 'no, the
> this error. The
> subscriber in either
> procedures on the
> the above error
> sp_scriptpublicationcustomprocs
> creates the procedures
> from a production
> error "Could not find
> the distribution
> Wizard" in the
> subscription from the very
> showed.
|||Later editions of BOL may have these details, but if not this link has more
details: http://support.microsoft.com/default...b;EN-US;299903
Regards,
Paul Ibison
|||Thanks
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uOnbmgthEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Later editions of BOL may have these details, but if not this link has
more
> details: http://support.microsoft.com/default...b;EN-US;299903
> Regards,
> Paul Ibison
>
|||Hi
do let me know if you've had any difficulties running
"sp_scriptpublicationcustomprocs".
After creating the replication as described in the KB 320499, if you see
that Inserts get replicated well but "updates" gives
us the Following error;
"37000 Cannot update identity column 'column1'. 8102 "
Do let me know.
SB.