Groups | Blog | Home
all groups > sql server replication > august 2003 >

sql server replication : Trans Replication, push subscription error: Could not find Stored Procedure sp_M


ldejesus NO[at]SPAM kaminodev.com
8/26/2003 12:14:39 PM
I created a transactional replication in SQL2000.

I decided not to create a snapshot of the schema and data
because the database in very big and it is already in the
subscriber. I restored a backup of the db in the
subscriber.

After creating the publication and then the subscription
with a push I started the synchronization.

As a result I get the following error: Could not find
stored procedure find sp_MSins_<Table_Name>.

Where is this sp created? How can I work this around?

help wil be highly appreciate it
David Russell
8/26/2003 12:56:45 PM
Most of the stored procedures for replication are in the
distribution database.

David
[quoted text, click to view]
AddThis Social Bookmark Button