When updating a column from a single row in a table from one server that is in replication with another server why doesn't the whole row update?
Example
Server 1
Table:CustomerInfo
Columns:
ID, Customer, Address, Status
Data:
25, John Smith,1523 Jack Creek, 2
Server 2
Table:CustomerInfo
Columns:
ID, Customer, Address, Status
Data:
25, John Smith,1523 Jack, 1
I need Server 2 to match Server 1 so i though if I just added a period to the end of the address in Server 1 it would also update the status from 1 to 2?
SQL for Server 1:
update CustomerInfo set address = address + '.' where id = 25
But all it is doing is updating the address correctly, but not update the status from 1 to 2. It used to update the entire row I'm wonder if there is a setting I changed somewhere that is preventing this from happening? I know I can update both fields at the same to, but I need to know why whole row is not being updated.
With this issue i am currently running Version SQL 8.00.2039 (SQL-DMF)
Thanks,
Jorge