Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  How to limit DB size for each user?

Author  Topic  Mojo Starting Member 19 Posts Posted - 2001-05-15 : 20:39:53 I need some direction as to limiting the size in MB that a user can have in the DB. Something like Yahoo! or others use. They indicate how much space you have left. I have not found a good way to either measure the size of each row the user has in the DB or to measure a table (if I were to assign a table to each user). There are over 4k users that will be online when it goes live and within 1 year there is supposed to be 57k users. Each users will have somewhere between 100 and 1000 records. I am not asking for someone to write the code for me. I just am not sure what direction to go and am hoping for a friendly shove the right way. Thanks, Joe