Marc,

There's really a lot of info behind "doesn't work", isn't it? Care to share?

>
>I created a linked server but I don't understand why the four parts names select doesn't work, while OPENQUERY() works fine
>
>Here are the two sample code I used to make test. ECHANGE is my linked server, using OLEDB Provider for SQL Server, G2MIR is the database and TEST is the table
>
>

select * from echange.g2mir.dbo.test
>
>select * from openquery(echange, 'select * from test')

>
>The OPENQUERY returns all datas from my TEST table, It permit me to insert or delete datas, but I'd prefer to use four parts select.
>