Post reply

maximum number of records

  • 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?

  • 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

  • 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?

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply