Hello I am replcating data (tables only) from SQL Server 2000 (SP3a) to SQL Server 2008 (SP2). Everything work fine I dont get any error copies the data to the subcriber database perfectly but does not do replication. when I check the agen job history it gives me error "Could not find stored procedure 'sp_MSdel_dboSessionContextNames'." I checked the master db and the publisher database (which i am replicating) but coulnt find it I also search online about that sp but no luck. so I am asking you guys can you give me a clue. I am also replicating another db from diffrent SQL Server 2000 and it is working fine. Any ideas I have to complete this project tomrrow. Thanks in advance.
what type of replication you configuring? Is it peer to peer transactional replication. If its so then both node need same enterprise version of sql server. Also I think you can do the subscriber for sql 2000 with publisher on 2008 but not the publisher for 2008 subscriber.
yes its transactional replication. I am replicating from sql server 2000 to sql server 2008. My distributer db and subscriber is on sql 2008. And my pubisher is on 2000.
SQL 2000 you should be on SP4 and SQL 2008 it is still on SP1 only, SP2 is on CTP. So are you testing the replication on a SQL 2008 CTP version of service pack?