transactional replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sam - 23 Dec 2006 02:35 GMT

please help !
i don't know why my store procedure of the transactional replication will be
recreate the store procedure everyday.
After that i will get the error like below:

error : Procedure or function sp_MSupd_transaction_orders has too many
arguments specified.

any solution for that?

thanks for help.

Reply to this Message

Hilary Cotter - 24 Dec 2006 02:44 GMT

This sounds like your publication table has fewer columns that the stored
procedure you are using to replication the commands. Sounds like you need to
regenerate the stored procedures. Use sp_scriptpublicationcustomprocs to
generate them, and then run them on the subscriber.

Signature

Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> please help !
> i don't know why my store procedure of the transactional replication will
[quoted text clipped - 8 lines]
>
> thanks for help.

Reply to this Message