Linked Servers

  • Hi,

    Kindly help me with the difference between OPENROWSET and sp_addLinkedServers. What does it mean by that OPENROWSET is a one time connection?? Even sp_addLinkedServers seems to be One time for OLEDB!! Help needed please!


    Regards,
    Genie Cool

  • OPENROWSET makes a connection to the remote server only for the period that connection requesting is open where as LINKED server is configured to access the remote server anytime and this would be a permanent configratuion until removed from the list of servers.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • Thanks..


    Regards,
    Genie Cool

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

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