sql server replication: Could not find stored procedure 'sp_MSupd

Could not find stored procedure 'sp_MSupd_mytable'

Wen Chang
11/29/2003 10:33:03 AM

sql server replication: Hi,

I have setup a one way transaction replication.

During creating the publication Artical,
in the 'Commands' panel, I have checked all boxes
in that panel including Create the stored procedures
during initial synchronization of subscriptions.

During creation of the subscription, if
I select 'Yes, initialize the Schema and data', there
would be no problem. If I select 'No, the subscriber
already has the schema and data' then the replication will
fail with 'Could not find stored procedure
sp_MSupd_mytable' msg when I update a record.

Please advise how to create those sp's without going thru
initial sync of subscription process.

Thanks for the help in advance.

WenChang

Could not find stored procedure 'sp_MSupd_mytable'

Paul Ibison
12/1/2003 8:17:34 AM

Have a look at sp_scriptpublicationcustomprocs in BOL.
Paul

[quoted text, click to view]

Could not find stored procedure 'sp_MSupd_mytable'

anonymous NO[at]SPAM discussions.microsoft.com
12/1/2003 8:56:58 AM

Thanks.

[quoted text, click to view]

Re: Could not find stored procedure 'sp_MSupd_mytable'

hansje
12/2/2003 4:11:38 AM

When I try to find sp_scriptpublicationcustomprocs in BOL I receive NO
TOPICS....
Where do I find them?
Running SQL2K sp3a

Tnx,

Hans Brouwer

*** Sent via Developersdex http://www.developersdex.com ***

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.