Maximum no of tables

  • Thread starter Thread starter S S Venkatesh
  • Start date Start date
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?
 
It's generally considered bad design to have separate tables for each
customer.
 
Back
Top