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

Nicholson, Karen knicholson at gpsx.net
Wed Jul 30 13:25:34 CDT 2003


No code needed.  Just set to zero.  How wonderful.

-----Original Message-----
From: Mike and Doris Manning [mailto:mikedorism at ntelos.net]
Sent: Wednesday, July 30, 2003 1:20 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Re: Sproc runs and then it doesn't


Yes.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Nicholson,
Karen
Sent: Wednesday, July 30, 2003 1:31 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Re: Sproc runs and then it doesn't


Do you mean on the options tab in Microsoft Access, if you set the "dont
display lists where more than this number of records read" to 0, it takes
off the limit?

-----Original Message-----
From: Nicholson, Karen [mailto:knicholson at gpsx.net]
Sent: Wednesday, July 30, 2003 1:27 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Re: Sproc runs and then it doesn't


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
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
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