sql server replication: I am trying to set up Transactional Replication and here is the
configuration.

Server1 - Publisher
Server2 - Dist
Server3 - Subs

Since the database was huge so I ended up making a backup from Publisher and
restored it on Subsriber.
When I was setting up Publication using EM, I Set up Article properties for
tables that DO NOT DROP EXISTING Tables on Subsciber because I had all
tables over there.

When I was pushing it, I chose the option Subsriber has Schema and Data.

Now my Replication Distribution Agents are failing giving following errors:

1. Couldn't insert a record. Missing sp_MSins_Customer
2. Couldn't delete a record. Missing sp_MSdel_Groups

and the list goes on forever.

Shouldn't SQL Server have created all the required Stored Procedures
sp_MS(INS, DEL, UPD) even if I don't want my Articles to be touched on
Subsriber Database or AM I MISSING SOMETHING.

I am sure someone out here definitely knows about this problem and has a
solution.

Thanks in Advance.

Have a look at:
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;299903
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com

(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)