SQL db table limit

[firestoper]

Hi Guru's I created a web application which is intended for multi users, I come up with an idea that every user who sign ups will have their own sets of tables instead of one row on the table with relations to other table, I'm just wondering whats the limit count of tables can a database (MSSQL2005) hold and is it a good advice to propagate table. regards Dom

[blakey404]

dont know the limit but that sounds like a horrible idea! GOOD LUCK!

[Ronni Marker]

Hi Dom, it is Limited by number of objects in the database. Take a look here: http://msdn2.microsoft.com/en-us/library/ms143432.aspx[^] Cheers, Ronni

[okdeshpande]

Hi, In MS SQL 2005 the ID column of Sysobjects table is Int. It means that you can create Max of integer. The integer datatype can hold value up to 2^31.

[firestoper]

Thanks for the nice feed from you guys, I guess I'm going to push it through though just to see how it goes when hits a thousand sign ups (day dream mode). I'll let you know when things start to mash up (couple of years I guess). regards Dom