Hi all,
Can someone help me in this. Suppose I have a SQL Server 7. For each user, I have to create a database. I have 50 users. In about 6 months time, the 50 users will have about 6-8 gb of data in the database. In such a situation, how would I maintain the database's functionality and performance.

I've put the thread in the database part, I thought there are a few database kings in this forum also. So, Ive put it in this.

Thanx in advance,
Parasuraman