SQL Server Performance

Expired subscription clean up job

Discussion in 'SQL Server 2008 Replication' started by klehonia, Nov 30, 2009.

  1. klehonia New Member

    Hi, i have set up a peer to peer replication (2 nodes, w2k8, sql 2k8 enterprise) and the 'Expired subscription clean up' job failed with error message 'The name 'db.sys.sp_MSdrop_expired_subscription' is not a valid identifier. [SQLSTATE 42000] (Error 203). The step failed.'.
    Does any one know what that means?
    Thank you in advance.
    klehonia, Nov 30, 2009
    #2

  2. ghemant Moderator

    Could you please post the complete error message? What is written in the error log and job history?
    ghemant, Nov 30, 2009
    #3

  3. klehonia New Member

    The message i 've written before, that's the error log in history job.
    klehonia, Nov 30, 2009
    #4

  4. satya Moderator

    What is the service pack on SQL Server?
    Also see if you can find that specific system catalog on master db?
    satya, Nov 30, 2009
    #5

  5. klehonia New Member

    sql 2008 enterprise sp1, this procedure is not installed, just the job runs the procedure sp_expired_subscription_cleanup which calls the sp_MSdrop_expired_subscription which i think creates temporarily and then drops. Somewhere in microsoft i found this http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=169247.

    klehonia, Nov 30, 2009
    #6

  6. satya Moderator

    If you have a support contract with Microsoft, then you could get a hotfix on this problem.
    satya, Dec 7, 2009
    #7

Share This Page