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

Nicholson, Karen knicholson at gpsx.net
Wed Jul 30 12:27:17 CDT 2003


Oh my, that is intuitive!

-----Original Message-----
From: Francisco H Tapia [mailto:my.lists at verizon.net]
Sent: Wednesday, July 30, 2003 12:26 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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>


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


More information about the dba-SQLServer mailing list