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