We are using SQL Server 2017 transactional replication and getting a data conversion error for one of our articles. The only difference between the publisher and the subscriber is a bit field that is NOT NULL on the publisher and NULL on the subscriber. Haven't been able to find any other problem that would account for this type of error. Any suggestions would be greatly appreciated.
What would the default value be on that bit column on subscriber side? If it is bit its either 1 or 0 or donyou have a 3rd state? Then should that column really be bit?