This is my scenario:
I have a varchar(max) column on a table that is replicated to other servers.
I have a stored procedure that does and update to this column and other columns on the table. This is done inside a transaction that also includes other updates. When I call the stored procedure, this one varchar(max) column's value is not replicated.
When I just run the single update statement on its own, the value is replicated.
Anyone know something about this?
View Complete Post