limitation of rows in table........

• bandarimohan 57273

  SSC Enthusiast

  Points: 196

  More actions

  May 2, 2012 at 8:20 am

  #273447

  As i am creating table in one database, so here how many records/rows can we create in one table per database.

  In sql server 2005/2000/2008. Is there any limitation for rows and all.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  May 2, 2012 at 8:22 am

  #1482413

  the only limitation on rows is the amount of storage you have on the disks the file(s) are on which hold the table