SQL Server Performance

Could not find stored procedure 'sp_MSdel_dboSessionContextNames'.mssqlserver error 2812

Discussion in 'SQL Server 2008 Replication' started by tariq745, Aug 17, 2010.

  1. tariq745 Member

    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.
  2. ashish287 New Member

    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.
  3. tariq745 Member

    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.
  4. ashish287 New Member

    Transactional but what type??
    is it normal transactional or peer-to-peer transactional replication
  5. satya Moderator

    What is the service pack level on both SQL 2000 & 2008 instances?
  6. tariq745 Member

    SQL Server 2000 = service pack 3a and on sql server 2008 i have service pack 2
  7. tariq745 Member

    SQL 2000 = sp3a and SQL 2008 = sp2
  8. satya Moderator

    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?
  9. dineshasanka Moderator

    http://www.sql-server-performance.com/faq/could_not_find_dbssp_msins_dbotest_p1.aspx

Share This Page