[dba-SQLServer]Re: Sproc runs and then it doesn't

Thanks Doris :)

-Francisco
http://rcm.netfirms.com

On Tuesday, July 29, 2003 1:53 PM [GMT-8],
Mike and Doris Manning <mikedorism at ntelos.net> wrote:

: If you set the default to 0, it will always return all the records.
:
: Doris Manning
: Database Administrator
: Hargrove Inc.
: www.hargroveinc.com
:
:
: -----Original Message-----
: From: dba-sqlserver-bounces at databaseadvisors.com
: [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
: Francisco H Tapia
: Sent: Tuesday, July 29, 2003 2:55 PM
: To: dba-sqlserver at databaseadvisors.com
: Cc: SQL Server 2k List
: Subject: [dba-SQLServer]Re: Sproc runs and then it doesn't
:
:
: My co-worker found an option in Access for the amount of records to
: limit the return to, in Access it is defaulted to 10k, for my home
: version it is set to this limit as well as here at work, but at home
: the results are as expected, at work I had to modify this result to >
: 10,000 records, I chose as a test 100,000,000 which yields the
: correct results.
:
<snip>