I have a MsSQL Server 2016 and a linked server MsSQL Server 2012. In the linked server there are some tables that contains columns of type "bigint". When I try to access data from these tables using a SELECT clause , the query returns the next message error :
OLE DB provider "SQLNCLI11" for linked server "..." returned message "Unspecified error".
Msg 8115, Level 16, State 2, Procedure "sp_tables_info_90_rowset _64, Line 9.
Arithmetic overflow error converting expression to data type int.
How can I solve this problem?
Thank you,
Mioara