SQL Server Link to Remote SQL Server Database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server Link to Remote SQL Server Database

Hi, I want to link a sql server db from my sql server. What I did is using Linked Servers to link the remote sql server db. But it seems that I can’t directly open the tables. I have to write sql statement to get the data in the tables. Is there a way that I can open remote tables ditrectly? Thanks in advance.

You can register another server in Enterprise manager by right clicking at the top of the server tree in the left-hand pane Cheers
Thanks Twan! It is exactly what I wanted.
If the server can be reachable then its best to register with Enterprise Manage rather than troubling with Linked server. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.