| Author |
Topic |
|
saurabh811
Starting Member
33 Posts |
 Posted - 2008-08-19 : 18:27:17
|
| Hi all,do any one know that how many tables you can create in sql server 2005.microsoft says tables per database is limited to no of objects in database.but i dont have any other objects in table.so how many tables i can create in one database.thankssaur |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-19 : 18:31:27
|
| This must be interview question.Correct |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-19 : 18:33:28
|
I doubt that this is an interview question as it would be pointless to ask this.From BOL:quote:
Database objects include objects such as tables, views, stored procedures, user-defined functions, triggers, rules, defaults, and constraints. The sum of the number of all objects in a database cannot exceed 2,147,483,647.
Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
saurabh811
Starting Member
33 Posts |
Posted - 2008-08-19 : 18:37:48
|
| well this is not interview question no this is point less.one of our application generate cache tables auotmatically..so we create one DB for that and it will create 2 to 5 tables every min in database through application.so we dont know hoe many tables will going to create through this application.so thats why i want to know what is it sql server limit to create max tables..saur |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
saurabh811
Starting Member
33 Posts |
Posted - 2008-08-19 : 18:41:59
|
| well what you mean redesign system??? its nothing with desiging...its just cache tables...we have also clean script..that will clean cache tables after certain time...but still i want to know how many tables sql server let us to create....thanks.. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
saurabh811
Starting Member
33 Posts |
Posted - 2008-08-19 : 18:55:43
|
| well if you dont know answer then pls dont give your irrelated comments.without looking my application how can you say its bed design..well i already told you its nothing with design..bcz there is no user activity,its only cache tables.and those tables will be deleted after 2 days by our cleanup script.my application create 500 tables within 24 hrs..but we dont know that how many tables it will going to create.so thats why i want to know,how many tables you can create in one database.thanks... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
saurabh811
Starting Member
33 Posts |
Posted - 2008-08-19 : 18:59:14
|
| thats oke..thanks very much for your time... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-19 : 23:43:26
|
| You should know sql server spec before making such design. |
|
|
|
|
tables per database in sql server 2005