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.
>
--sb--