SQLServerCentral Logo SQLServerCentral Logo
  • Articles
  • Editorials
  • Stairways
  • Forums
    • Forums home
    • Active threads
    • Latest topics
    • Most popular
    • Leaderboard
  • Scripts
  • QotD
  • Books
  • Blogs
  • Register
  • Login
  • Write for us
  • Menu
  • Articles
  • Editorials
  • Stairways
  • Forums
    • Forums home
    • Active threads
    • Latest topics
    • Most popular
    • Leaderboard
  • Scripts
  • QotD
  • Books
  • Blogs
  • Write for us
  • Register
  • Login

Home Forums SQL Server 2005 Working with Oracle 100-row limitation using Oracle Linked Server RE: 100-row limitation using Oracle Linked Server

  • Jo Pattyn

    SSC-Dedicated

    Points: 32613

    More actions

    June 15, 2014 at 12:21 pm

    #1721797

    Didn't know about the bug, glad you mentioned it.

    100 is the default fetchsize for the Oracle Client, you might increase it through the registry/provider string

    • About SQLServerCentral
    • Contact Us
    • Terms of Use
    • Privacy Policy
    • Contribute
    • Contributors
    • Authors
    • Newsletters
    Redgate logo