Linked Servers

Question

Linked Servers

bvsc

Ten Centuries

Points: 1258
More actions
March 8, 2011 at 10:33 am

#235905

Hi I dont know, weather this is valid question or not?
So when we establish the linked servers, we can be able to see all the servers linked under the current server.
It should be either from sys.servers or through GUI on SSMS server->server objects->linked server.
My question is I will be able to see all the servers (for example : 3 servers) all information like tables, sps etc...
So inorder to keep them here to display Does sql server use memory/space ? how it will work?
Can someone explain this? Thanks in advance.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

ypk1984 (3/8/2011)
Hi I dont know, weather this is valid question or not?
So when we establish the linked servers, we can be able to see all the servers linked under the current server.
It should be either from sys.servers or through GUI on SSMS server->server objects->linked server.
My question is I will be able to see all the servers (for example : 3 servers) all information like tables, sps etc...
So inorder to keep them here to display Does sql server use memory/space ? how it will work?
Can someone explain this? Thanks in advance.

It runs a query on demand, based on your selection in the GUI; SQL doesn't keep polling the linked server or anything.

so when you expand a linked server to see it's objects in SSMS, the command sp_tables_ex LinkedServerName is issued, and the results are displayed in the GUI as the list of tables, etc.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!