sql server msde: Lets get practical here. Assuming that not all databases are used at once
and autoclose is on I believe you could support 1000 or so. Maybe more, but
you do run into some Windows limits because of the number of open files.
There was a design done at Microsoft years ago for a bCentral hosted
accounting solution that was released and then pulled from the market when
Mcrosoft acquired Great Plains. It used this technique (a database per
customer using autoclose so that a much smaller number of databases/files
were open at any given time). A white paper (that didn't reference what
actual application they were talking about) described how to do this. I can
no longer find the white paper. Anyway, I believe they proved they could
support a few thousand databases.

--
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com



[quoted text, click to view]

Is there a limit on how many databases you can have per. MSDE instance?

Best regards
Erling Johansen
Norway

Hi

Standard SQL Server limit of 32'737

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]