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