BamBam
3/21/2007 2:25:00 PM
I am using SQL-DMO to return a large number of records from SQL Server
back to the calling VBS program. I am able to connect and retrieve
records from the database as long as the query returns about 8,000
records.
However, the query does not return any records when I try to retreive
10,000 records. I can run the 10,000 row query in SQL Analyzer
without a problem. However, it returns 0 rows when the same query is
run using SQL-DMO.
Is there some "Maximum Number of Rows" or "Maximum Number of Bytes"
parameter that needs to be set? If so, what is it called? I cannot
find it in the SQL Server Books help.