We have two different servers one is SQL server 2005 another which we recently migrated to SQL Server 2019.
Linked server query is running properly on sql server 2005.but issue in the SQL server 2019. it throws "
Msg 8114, Level 16, State 10, Line 1Error converting data type DBTYPE_DBDATE to date." Please have a look at the date column which has not in the "yyyy-MM-dd hh:mm:ss:fff" .SQL SERVER 2019:SQL SERVER 2005:If you see the same column in SQL server 2005 .which is
in the "yyyy-MM-dd hh:mm:ss:fff" .
May I know the issue. Please help me on this?
------------------------------
bhimagonolla sureshgoud
------------------------------
#Informix