Merge Replication issues after in place upgrade to Sql 2012 RRS feed

  • General discussion

  • We performed a in place upgrade from 2008 R2 to SQL 2012 and not our synchronization agents are in error with the following.  I searched and read the article on upgrading replicated databases and we did all those steps.  No schema changes happened during this process, databases were upgraded according to the error log but they are still running in 10 compatibility mode

    Msg 257, Level 16, State 3, Procedure MSmerge_ins_sp_87644A0BC02A43A7935B8E2D84404349000, Line 0

    Implicit conversion from data type nvarchar to varbinary is not allowed. Use the CONVERT function to run this query.

    Is there a way to re-generate the merge procs without having to reinitialize

    Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz

    Wednesday, August 8, 2012 10:30 PM

All replies