maximum number of records

• Steel83

  SSC Veteran

  Points: 252

  More actions

  February 26, 2008 at 11:07 pm

  #203680

  HEllO All,

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

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 26, 2008 at 11:10 pm

  #782360

  Plase don't post multiple threads on the same problem. It wastes people's time and fragments replies.

  Replies to the following thread please - http://www.sqlservercentral.com/Forums/Topic460688-146-1.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• JDixon-385826

  SSCrazy

  Points: 2723

  More actions

  February 26, 2008 at 11:41 pm

  #782365

  good question: I have seen billions of rows in tables. Not sure what the maximum would be but I am guessing you would run out of disk space before you hot the maximum. Depending on so many things. but you could run and insert in a endless loop and see.

  Is there a more specific question?

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  February 27, 2008 at 9:24 am

  #782616

  That depends on the disk space and SQL Server does not restrict you directly with this.

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