Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2002
    Posts
    1

    Unanswered: 2k Replication errs .... Error 2812

    Hey,
    Having some probs w replication between 2 2k srvs running sql2k.

    The dist agent is experiencing errors..........

    "Could not find stored procedure 'sp_MSins_tester'

    Error number: 2812

    Initially it gave an error of 18452 on dist agent of Could not connect.
    I updated the id/pw for the subscriber and that went away and generated the above.

    Any thoughts on what I should try next?

    --matt

  2. #2
    Join Date
    May 2002
    Location
    Cape Town , South Africa
    Posts
    30

    Cool error 2812

    Hi Matt ,

    from what I have experienced (both errors) you will have to create a stored procedure for you dist agent , that you should solve the problem.you might want to check sql books online there is more info there.


    Hope this helps in some way..

    Regards
    Burner

  3. #3
    Join Date
    Dec 2002
    Posts
    1

    Lightbulb what did you do ?

    What did you end up doing to get by this problem ?

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Which service pack do you have installed for sql server 2000 (on both sql servers) ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •