microsoft.public.sqlserver.server

Author

Records Limit

Peter

2002-12-19, 4:24 pm

Dose SQL 2000 std server have a record limit for table?

THKS

Mike John

2002-12-19, 4:24 pm

Yes but not a practical one for all normal purposes. 1 table can span
multiple files, each file can be 32 Tb, so practical issues like affording
the discs tend to come in well before the theoretical limits.

Mike john

"Peter" <peteryu@adm.com> wrote in message
news:07ad01c2a7aa$1f6c10d0$89f
82ecf@TK2MSFTNGXA01...
> Dose SQL 2000 std server have a record limit for table?
>
> THKS

Gert-Jan Strik

2002-12-20, 11:23 am

No, according to BOL (under Maximum Capacity Specifications):

Rows per table: Limited by available storage

Gert-Jan

Peter wrote:
>
> Dose SQL 2000 std server have a record limit for table?
>
> THKS

Sponsored Links