tag:blogger.com,1999:blog-4639656271502429319.post3648848499806195218..comments2023-07-27T03:49:29.762-07:00Comments on Matt Slocum's SQL Blog: I've Got The SP2 Replication Blues - SP2 For SQL 2014 Changes A System SPROCMatt Slocumhttp://www.blogger.com/profile/12250451871941307366noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4639656271502429319.post-14658715944604591712016-10-03T02:16:42.921-07:002016-10-03T02:16:42.921-07:00Nice! Glad to hear you recovered from that one. ...Nice! Glad to hear you recovered from that one. We had something similar, this time with 2 PUB's, upgraded the 1 PUB with bi-directional\2-Way\UpdatableSubscriber whilst the other PUB (the SUB to the PUB we upgraded) was left on older patch level, and the upgrade of replication removed the system stored-procedure but never recreated it:System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.sp_MSsync_ins_TableName_Nr'.<br />Meaning updates at the subscriber never made its way back to the publisher...<br />A simple drop and recreation of the subscription solved it.gras_piesanghttps://www.blogger.com/profile/05765333387336112850noreply@blogger.comtag:blogger.com,1999:blog-4639656271502429319.post-57988958335692746362016-09-20T14:18:47.667-07:002016-09-20T14:18:47.667-07:00you rock :)you rock :)Aditya Baradwajhttps://www.blogger.com/profile/02857424780451578505noreply@blogger.com