I have two servers with
SQL SERVER 2014the communication between them takes place via a Linked server,
I run one
update simply update the table data of the
server A for the
server B, but I get the following error:
Message 242, level 16, status 3, **, line 22 The conversion of a type
varchar data in a datetime data type resulted in a value
out of range.
I left the two users with the same language that I already used
SET DATEFORMAT in every way, but to no avail.
What do I have to do to be able to execute? because it's a problem converting data.