question

Mioaramitrea-1916 avatar image
0 Votes"
Mioaramitrea-1916 asked SeeyaXi-msft commented

Msg 8115 on a linked server SQL 2012

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

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Mioaramitrea-1916 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it dosn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @Mioaramitrea-1916,

So install the latest service pack and CU on the SQL Server 2012 (and 2016).

Agree with Olaf.
If it dosesn't work, please refer to these to check the process of creating linked server.
https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine?view=sql-server-ver15
https://www.sqlshack.com/how-to-create-and-configure-a-linked-server-in-sql-server-management-studio/

Best regards,
Seeya

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.