>OT: what is the max number of tables SQl 7.0 can handle?
From SQL Server books online ...
"Database objects include all tables, views, stored procedures, extended
stored procedures, triggers, rules, defaults and constraints.
The sum of the number of all these objects in a database cannot exceed
2,147,483,647."
So the answer is it depends on what else has been defined. Absolute
maximum is about 2 billion.
Bruce Ford [EMAIL PROTECTED]
Online Teaching Systems Coordinator
Teaching and Learning Support Services Ph: +61 7 3864 9773
Queensland University of Technology
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
