Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Capacity Limit of a table in SQL server

Status
Not open for further replies.

tumkursudhi

Programmer
Mar 5, 2003
10
0
0
JP
We are designing a data base in SQL server and are planning to come up with a single table of capacity of 100 Giga bytes. Apart from the time constraint, will this be possible to realize? If not what would be the constraints?
thanks for your kind advise.
 
Refer to the BOL, use the Index tab, enter Capacity. That should bring up Capacity Specifications-SQL Server.

The maximum number of objects in a database is 2,147,483,647. Objects include views, tables, stored procedures, defaults, triggers, etc.

-SQLBill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top