we have SQL replication running and on our replicated database users are getting errors in our app that related to SQL
so i went onto the sql database at that site that is replicated and started diagnosis
Update Clients Set ContactNumberSecondary ='123' where ID = 13031
Msg 206, Level 16, State 2, Procedure sp_MSsync_upd_Clients_1, Line 0
Operand type clash: smallint is incompatible with date
The statement has been terminated.
this command runs fine
select * from Clients where ID = 13031
ive searched and searched and have come up trumps, ive checked the table for datatypes and everything is fine, ive seen errors about column layout in the two tables, it matches
WHERE table_name = 'Clients'
ORDER BY ordinal_position
on both tables and the spreadsheet attached shows both tables match completley
anyone know any other ways to troubleshoot and solve this?