maximum number of records

• Steel83

  SSC Veteran

  Points: 252

  More actions

  February 26, 2008 at 11:07 pm

  #124243

  HEllO All,

  Please TEll me what is the maximum number of records that can be kept in a table on sql server 2000?

• peterhe

  SSChampion

  Points: 11469

  More actions

  February 27, 2008 at 7:00 am

  #782480

  SQL Server does not have hard limit for rows in a table if you have enough disk space.

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  February 27, 2008 at 9:00 am

  #782590

  It depends on your disk space. SQL Server has no restrictions to that.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com