sql server replication: hi,
I have two Sql servers running sql 2000 enterprise edition
I am restoring a pubs database from the backup(it is of pubs database on server A) on server B and i named it pubs_restored. On another box on Server A in pubs databse I am creating a publication of transactional replication type on pubs database of Server A. Then i am creating a pull subscription on pubs_restored database on server B with selecting the option of 'No , subscriber already has the schema and data'.

Now when i add a record in a author or any other table i gets an error stating that sp_Msinsxxxxxx not found. and replication fails.

so how can i fix that so those store procedures can be created on pubs_restore db on server B
(I can create those sp mannually but i am not sure whether it will cause other issues or not)

You can use the sp_scriptpublicationcustomprocs procedure to script the
procedures that are missing. When you do a manual sync then the procedures
must be added manually at the subscriber.

Rand
This posting is provided "as is" with no warranties and confers no rights.