Maximum no of tables

S

S S Venkatesh

Hi
I am maintaning each table for a customer and number of customer
keeps on increasing. How should this be handled if the number of tables
keeps on increasing?
How many tables can a database have? ( I am using sql server 2000)
Can i create another database in another server if the database size reaches
the limit? if yes how?
 
D

Douglas J. Steele

It's generally considered bad design to have separate tables for each
customer.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
You don't currently have permission to access this folder 0
Footer On Last Page Only Not Working 1
Combo or list box 0
Copy previous record into form field 0
Keeping Track Of Daily Sales 6
How to count the numbers in a Word document? 0

Top