Post reply

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

  • November 20, 2006 at 11:31 am

    #173506

    Many thanks for any input in advance.

  • 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

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

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

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