Hi Marc,

You can create a linked server and than run queries agains it using four parts names (server.db.dbo.table) or OPENQUERY() function. You can also use OPENROWSET() function. See BOL for details.

>
>Can somebody help me to make a SELECT on a distant SQL server.
>
>For example, I have a stored procedure which is runningon a SQL server (1)and I must import datas from another SQL server (2). I tested several kind of SELECT, but nothing works.
>
>Any help is welcome.
>
>Thanks