Results 1 to 3 of 3

Thread: MSSQL 2000 Linked Server, 99 rows missing

  1. 09-05-2007, 09:50 AM #1
    ping
    ping is offline Registered User
    Join Date
    Sep 2007
    Posts
    1

    MSSQL 2000 Linked Server, 99 rows missing

    Hi,
    I've a linked server in MSSQL 2000 SP4 that links to a Oracle DB version 9.

    When I run a simple query that is supposed to return total records from the Oracle DB above via Linked Server in the Query Analyzer, I always have 99 rows of records missing. For example, the query is expected to return 1099 rows; however there is only 1000 rows returned. It happens to all the queries made via the Linked Servers.

    Have anyone ever had this problem before? Any resolution?

    Appreciate for the reply.

    Thanks!
    Reply With Quote Reply With Quote
  2. 09-05-2007, 10:38 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Which provider did you use? Tried with other provider?
    Reply With Quote Reply With Quote
  3. 09-07-2007, 06:59 AM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Do you always miss 99 rows?

    Sounds like you

    SET ROWCOUNT 1000

    set. Run

    SET ROWCOUNT 0

    and try again
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules