14,494 questions
So install the latest service pack and CU on the SQL Server 2012 (and 2016).
Msg 8115 on a linked server SQL 2012
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 6%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mioara mitrea
1
Reputation point
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 Other
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Seeya Xi-MSFT 16,586 Reputation points2021-07-02T07:10:42.007+00:00 Hi @Mioara mitrea ,
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.
Sign in to comment
2 answers
Sort by: Most helpful
-
-
Seeya Xi-MSFT 16,586 Reputation points
2021-07-01T03:24:00.043+00:00 Hi @Mioara mitrea ,
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://learn.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.