Max database and tables 1

[rtshort]

I'm just getting into SQL server for a database. What is the size limit to a database in SQL, overall and tables. I was told there was not limit to the number of tables and the size will grow if it is set to do so. Is this true or is it best to keep tables and max size to a certain limit. After all is said and done, I'll probably have in the neighborhood of 200 to 300 tables. They will be text data only and no BLOB. Every day above ground is a GOOD DAY!!!

 

[tlbroadbent]

Database size: 1,048,516 TB
Max Tables: See objects in a database
Objects in a database: 2,147,483,647

Of course, there are physical limitations on your hardware and other considerations. Limits differ for different versions and editions. Check the following link for more info.

Maximum Capacity Specifications SQL 7 and SQL 2000

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[rtshort]

Thanks for the info and the link. Every day above ground is a GOOD DAY!!!