"If you're talking about scaling to 50 users, probably not a big deal. But maybe. If 5000, you definitely want to take a really hard look at your design, and above all else: read "Transactional COM+" by Tim Ewald."
The design we are taking is that when we start hosting, we have to keep different clients data in different databases, at least that's what my boss says because the clients wouldn't go for their data sharing a DB with another company. Of course, we can't put to many companies data on one SQL server, so we were going to have everybody pass in what company they belonged to and we would know what server and DB to use for that user. You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
