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.
Li

You can register another server in Enterprise manager by right clicking at the top of the server tree in the left-hand pane Cheers
Twan

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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>