I have a SQL 2000 transactional replication setup for a database. I tried to subscribe to the publication from a SQL Server 2005 database. The subscriber is created successfully, which I made a pull type, but the replication stored procedures required for Insert, update and delete are not created. I know how to create the stored procedures for a single article. Is there any way I can move the entire set of stored procedures required for all the articles? Please help.
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.