SQL Server Performance Forum – Threads Archive
SQL Server Link to Remote SQL Server DatabaseHi, 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.