Can not set up replication on a single table

[mihaildamjan]

I am trying to set up replication between two servers on a single table but it keeps failing on the same place.

I am setting up replication on "AGENCY" table.
Message is:
"Could not find stored procedure 'sp_MSupd_agency'."

Is this stored procedure supposed to be created in "distribution" database, or in receiving database, or else?
Why is SQL server 2000 not creating this procedure, some kind of bug ?!?

I did set up replication a couple of years ago without problem at all, but it was on SQL server 7.

I am not new to this and I am pretty sure that I've set up replication monitor, publisher and subscriber correctly...

Did anybody have problems like this with SQL server 2000?

Any answer to this is greatly appreciated.

Mihail Damjan
SR. DBA/Systems Analyst
Chubb Security Americas
5201 Explorer Drive
Mississauga, ON.
L4W-4H1
Phone: 905-206-8522
Cell: 416-845-0018
Fax: 905-206-8494
Mailto: mihail.damjan@chubbsecurity.com