Marc,

What are the versions/Service packs of the local and remote SQL Servers? How did you create linked server and what options did you specify? What kind of security did you set for linked server?

>
>I should give you the error returned by >>

select * from echange.g2mir.dbo.test

>
>The result message is
>Serveur : Msg 7399, Niveau 16, État 1, Ligne 1
>OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information about the error.
>OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IUnknown::QueryInterface returned 0x80004005: The provider did not give any information about the error.].

>
>I hope it will help you
>
>