General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2000
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only