question

caustin avatar image
caustin asked

I am setting up replication and i am receiving a "The data types date and datetime are incompatible in the add operator. (Source: MSSQLServer, Error number: 402)" error

I am trying to setup transactional replication between two server. Both server are running Windows 2016 with SQL 2017 Standard edition. In setting up the environment i am accepting all of the defaults for the tables. The table replication starts to work, but then terminates with the above error. How do it address this error.

sql-serverreplicationdatetime
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·

Can you narrow the problem down to a particular table? If so, then we might be able to help more if you can then share the schema for that table.

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.