SQL Server 2000 Database Table Limit?

25 pts.
Tags:
SQL Limits
SQL Server 2000
SQL Server database
SQL Server tables
Is there a limit to how many tables a single database can hold in SQL 2000?

Answer Wiki

Thanks. We'll let you know when a new response is added.

There is not really a limit to the actual number of tables rather there is a limit to the number of total database objects, which include all tables, views, stored procedures, triggers, rules, defaults, constraints, etc…

When you take the sum of all of those elements, they cannot exceed 2,147,483,647.

I think you would want to ensure you have the capacity, memory, hard drive space, etc. Interesting question though…

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    I think you can have 2,147,483,647 objects, but I couldn't find any oficial source to confirm it.
    69,175 pointsBadges:
    report
  • Xarly
    Thanks Carlos. I looked myself, but couldn't find anything in a quick search either. If what you say is true, that is very helpful. Thanks. Chris
    25 pointsBadges:
    report
  • Fontanatech
    Here is the source: http://msdn.microsoft.com/en-us/library/aa933149(SQL.80).aspx
    265 pointsBadges:
    report
  • Xarly
    Excellent, the exact source I was looking for. Feel kind of stupid not thinking to look directly into MSDN. Well, I think 2+ billion objects is suffice for my project. Thanks for your time guys. Regards, Chris
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following