InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 02:50:09 GMT20http://www.sqlservercentral.com/Forums/Topic580141-291-1.aspxOn which Version is the Distributor?Wed, 08 Oct 2008 12:53:57 GMTsrawanthttp://www.sqlservercentral.com/Forums/Topic580141-291-1.aspxI have never worked on this scenario ( 2K publisher and 2005 subscriber), but here is what i think about it:-1. Did you run the snapshot agent and apply the snapshot once ? ( ps: kinda obvious but just checking )If you have ensured that the snapshot was applied at the subscriber and still you dont see the SPs, then you can create a subscription on some test database in 2K server and then copy over the stored procs from there to your 2005 server.Hope that helpedFri, 03 Oct 2008 16:43:56 GMTNikhil Shikarkhanehttp://www.sqlservercentral.com/Forums/Topic580141-291-1.aspxI 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.Fri, 03 Oct 2008 03:05:11 GMTChandrachurh Ghosh