I have created linked server between sql server 2000 and sql serevr 2008 and it display db and table under this but when I run select statement it gives following error
SELECT * FROM [102.101.10.34].TA.dbo.acTransactionData
Arithmetic overflow occurred.
Arithmetic overflow occurred.
Arithmetic overflow occurred.
Arithmetic overflow occurred.
Arithmetic overflow occurred.
Arithmetic overflow occurred.
Arithmetic overflow occurred.
Msg 7392, Level 16, State 2, Line 1
Cannot start a transaction for OLE DB provider "SQLNCLI10" for linked server "102.101.10.34".