Alternative to OPENROWSET

Posted on 2011-05-06
Last Modified: 2012-08-14

Im pretty new to SQL and would like to know if I can use other methods than OPENROWSET in my stored procedure to retrieve data from an external database?

Maybe mention the pros and cons...
Question by:Madsing
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    I'd consider linked servers as one of the alternatives. The big advantage is that you can use them as if they were SQL severs.
    LVL 21

    Expert Comment

    by:Alpesh Patel
    Linked server.
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    Yes and linked server of course, sorry I forgot about that one.

    Author Comment

    Actually Im also planing to replicate date between the two servers. Would linked server be a performance enhancement or how does linked servers works in relation to replication?  
    LVL 22

    Accepted Solution

    I think you can use replication with linked servers. See this article:
    Although for 2000 I suppose this still applies to 2008.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Suggested Solutions

    Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now