For one off adhoc queries you could use OPENROWSET, however, if this is a more permanent link then you must set up a linked server. Through enterprise manager go into the Security section and then Linked Servers. Right click and add, just step through the wizard. You can do it programtically with sp_addlinkedserver have a look at it in BOL.

Let me know how it goes.

Regards,

Jon


>From SQL Server Group named SOL-BOS02\SQL_A, I want to access to table located in SOL-BOS02\SQL_B. Then I have proceeded like this...
>
>--> Here I am in SQL_A server <--
>select * from [SOL-BOS02\SQL_B]..MyDatabase.MyTable
>
>But I got the following error message:
>"Server: Msg 7202, Level 11, State 2, Line 1
>Could not find server 'SOL-BOS02\SQL_B' in sysservers. Execute sp_addlinkedserver to add the server to sysservers."
>
>Does I need to add the 2nd server info into table sysservers to see it?
>Or there exists another way to include another server into my Select SQL?
>
>By the way, it it possible to create a view on a linked server? Because, when I attempt to create a view, in the list of available tables, I cannot see others than local tables.
>
>Thank you in advance!
>Marc