The Adaptive Server Enterprise OLE DB Provider now supports DBPROP_MAXROWS, a rowset property that you can use to limit the number of rows returned in a row set. The default value of this property is 0, which indicates no limit to the number of returned rows.
See the Microsoft Developer Network.
