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.
  2. ghemant Moderator

    Could you please post the complete error message? What is written in the error log and job history?
  3. klehonia New Member

    The message i 've written before, that's the error log in history job.
  4. satya Moderator

    What is the service pack on SQL Server?
    Also see if you can find that specific system catalog on master db?
  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.

  6. satya Moderator

    If you have a support contract with Microsoft, then you could get a hotfix on this problem.

Share This Page