What is the maximum number of rows that a single SQL Server table can store?


How many rows can we place in a single SQL Server table?

There is no limit, except maybe for your hard drive size.

Have a look at Estimating the Size of a Table

and Maximum Capacity Specifications for SQL Server : Rows per table

Tables per database : Limited by number of objects in a database

Database objects include objects such as tables, views, stored procedures, user-defined functions, triggers, rules, defaults, and constraints. The sum of the number of all objects in a database cannot exceed 2,147,483,647.