Hai,
We are working in a project which handles lots of data.
How many tables can we have in sql server 2000 so that it can be managed efficiently.Is there any rule for separating the tables.
We store information like candidate details,interview process....
Thanking in advance
sweetsasthi
0
Light Poster
Recommended Answers
Jump to Postsonia sardana>I dnt knw about exact limit but u can craete upto 50,000 tables...& i think so its more than enough...........What u mean by separating tables???? U mean primary table & foreign key table?
sweetsasthi>We are working in a project which handles lots of data.
How many tables can …
Jump to Postbabbu > u can hav as many tables as u want.
When you deal with computers you deal with restricted resources. See Maximum Capacity Specifications for SQL Server 2000. It says:Database objects …
All 6 Replies
sonia sardana
-13
Posting Whiz
sweetsasthi
0
Light Poster
kvprajapati
1,826
Posting Genius
Team Colleague
sweetsasthi
0
Light Poster
babbu
-12
Posting Whiz in Training
Teme64
215
Veteran Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.