ReplTip – Technique to exceed column limits for Merge Replication

Chris SkorlinskiMicrosoft SQL Server Escalation Services While working with a customer on a Merge Replication project, we encounter a potential road block. They had a published table which exceeded the number of columns allowed for Merge Replication. From this article https://technet.microsoft.com/en-us/library/ms151749(v=sql.105).aspx: If your application does not require column-level tracking, it is recommended that you use…


CDC functionality may break after upgrading to the latest CU for SQL Server 2012, 2014 and 2016

Chris SkorlinskiSQL Server Escalation Services This problem was brought to our attention recently by one of our customers. CDC LogScan job fails, possible Error Message: Log Scan process failed in processing log records.Operand type clash: int is incompatible with uniqueidentifierOperand type clash: int is incompatible with datetimeThe Log-Scan Process failed to construct a replicated command…