This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 请问各位DX：I have a table in SQL server 2000, I found the default max. rows is 1000, how to set tp it as unlimited...Thanks...
-shinning(dudu);
2003-4-4
(#1122204@0)
-
what do you mean the default is 1000? I never used a SQL 2000 default rows is 1000. millions records is no problem.
-ningxin0809(雁影行洲);
2003-4-4
(#1122211@0)
-
maybe I'm wrong, I just see a message" max. number of rows to fetch is 1000" :-)
-shinning(dudu);
2003-4-4
(#1122220@0)
-
It's not the max row number, it means if you retrieve more than 1000 rows' data from the table, you will get 1000 at a time, however, you can still retrieve the rest.
-xhis(xhis);
2003-4-4
(#1122376@0)
-
thanks!!!!!!!!!!!!!!!!!!!!1
-shinning(dudu);
2003-4-4
(#1122880@0)
-
I'm a new police for SQL SERVER...*-*
-shinning(dudu);
2003-4-4
(#1122222@0)
-
and do you know how many rows can be storeed in ACCESS????thanks
-shinning(dudu);
2003-4-4
(#1122224@0)
-
don't know. you can check the manual. one table in Access 2000 is about 25000? not sure. access 97 and access 2000 there is a big sifference.
-ningxin0809(雁影行洲);
2003-4-4
(#1122226@0)
-
thank you, but I have a table in ACCESS, the records already more than 25000 rows. and I can not find any info in the manul and books :-(
-shinning(dudu);
2003-4-4
(#1122233@0)
-
our DBA told me the 25000, but it depands on your row's size. We found there was a problem after 30000, that new records were not guranteed to be saved to database. and the guy found this message.
-ningxin0809(雁影行洲);
2003-4-4
(#1122245@0)
-
how did you do with it after you found this problem???chang to SQL SERVER????
-shinning(dudu);
2003-4-4
(#1122251@0)
-
yes
-ningxin0809(雁影行洲);
2003-4-4
(#1122252@0)