TallyList : mailing list management, archiving, and analysis

Archive of:
CF-Server
Cold Fusion Server Tech

home
24 hour view
quick stats
weekly updates

all tallylists
corporate solutions
archive your favorite
help / feedback

About Cold Fusion :
product's home
product's list home

Archived TallyList / CF-Server:
Subject: Re: OT: max tables

Bruce Ford (4p/+0r) Posted: Monday 01 Jan 2001
This post: 87 views, +0 rating

>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 b.ford@qut.edu.au 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 cf-server-request@houseoffusion.com with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com

Similar Subject Line Posts (+/- two weeks of this post)

RE: max tables	02 Jan 2001	(39 v/ +0 r)
Re: OT: max tables	01 Jan 2001 (this post)	(87 v/ +0 r)

Send a reply to the CF-Server list!
	NOTE: Many lists will reject your post unless you have already registered with them. Also - don't forget the right account to send from (for those with multiple emails!)