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