Would some like to summarize the difference between a registered SQL Server and a linked SQL Server?

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  November 20, 2006 at 11:31 am

  #173506

  Many thanks for any input in advance.

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  November 20, 2006 at 1:10 pm

  #673051

  quote: Would some like to summarize the difference between a regist...

  Huh??? What are you asking?

  -SQLBill

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  November 20, 2006 at 1:36 pm

  #673060

  Would some like to summarize the difference between a registered SQL Server and a linked SQL Server?

  I did not notice the top was truncated without notice.

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  November 21, 2006 at 3:07 am

  #673141

  A very short summarization would be that a 'registered server' is a link between your client tool and a SQL Server. (ie Enterprise Manager and a server), while a 'linked server' is a link between a SQL Server and a OLE DB datasource (ie SQL Server and another SQL Server, other DB of other brand or datasource in general)

  BOL (Books On Line) has a deeper description and overview of the linked server concept.

  /Kenneth