Multumesc pentru raspunsuri. Partea proasta e ca nu pot sa folosesc select simplu deoarece una dintre tabele fiind timestamp nu merge sa mi-a aduca da eroare: 

Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "LinkedServer" supplied inconsistent metadata for a column. The column "timestamp" (compile-time ordinal 66) of object ...  was reported to have a "DBCOLUMNFLAGS_ISROWVER" of 0 at compile time and 512 at run time.