I have replitation setup from sql 2008r2 publication to 2012 subscriber it was working fine and after 4h i faced error:

Error messages:
The process could not execute 'sp_replcmds' on 'PB01\PROD'. (Source: MSSQL_REPL, 
Error number: MSSQL_REPL20011)
Get help: http://help/MSSQL_REPL20011
Could not locate text information records for the column "Komentarz", ID 5 during 
command construction. (Source: MSSQLServer, Error number: 18773)
Get help: http://help/18773

this column is text datatype...

I found similar problem here Replication Error when adding small table as new article but i was not adding new table and potential solution is kb 2655789 but this kb does not exists anymore and as far as i googled it is for 2012 only.

Is there solution for 2008r2 also ?

Or perhaps can it be this subscriber 2012 issue? we will try sp4 on this 2012 that contain this KB but i think that this is publication - if subscription would be the problem then this message would apear in distributor to subscriber logs.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.