Return records through a linked server that uses ODBC data source

From: Lance (with2000_at_21cn.com)
Date: 08/05/04

  • Next message: Refky Wahib: ".Net Scalability problem" 
    Date: 4 Aug 2004 20:53:55 -0700

    Hi,

    I used sp_addlinkedserver to link to a remote server through ODBC.
    When I execute select count(*) from LinkSrv.SI.DBO.SIHeader in SQL Query
    Analyzer. It returns 13705 records. But when I execute select * from
    LinkSrv.SI.DBO.SIHeader. It only return 885 records. If I specify some
    columns, select ODCOMP, ODPONO, ODVDCD from LinkSrv.SI.DBO.SIHeader.
    It returns more records, 1213 records.

    I guess there is something limit the return storage, but I can not
    find it.

    Any suggestion will be appreciated. Thank you

  • Next message: Refky Wahib: ".Net Scalability problem"

    Relevant Pages