sql server replication: Error number: 2812 - Transaction Replication -- sql server replication

Error number: 2812 - Transaction Replication

Anoop
8/6/2004 2:45:02 AM

sql server replication:

Hi,

I am trying transactional replication between two servers with a remote
distributor. I am getting following error each time I run the distribution
agent

Last Command : {CALL sp_MSupd_Customers (NULL,N'Alfreds Futterkiste -
test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'ALFKI',0x0200)}
Transaction sequence number and command ID of last execution batch are
0x0000001A00000082000900000000 and 1.

Error Message :Could not find stored procedure 'sp_MSupd_Customers'.

Error details : Could not find stored procedure 'sp_MSupd_Customers'.
(Source: L000646\AA03 (Data source); Error number: 2812)

Can some one help please

Re: Error number: 2812 - Transaction Replication

Anoop
8/6/2004 5:03:03 AM

Thanks for that Paul. It is all working now.

regards

[quoted text, click to view]

Re: Error number: 2812 - Transaction Replication

Paul Ibison
8/6/2004 11:50:50 AM

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

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.