Number of databases per. MSDE instance?

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/
"Erling Johansen" <erlingpj@.hotmail.com> wrote in message
news:e6sGVMj6FHA.3136@.TK2MSFTNGP09.phx.gbl...
> Is there a limit on how many databases you can have per. MSDE instance?
> Best regards
> Erling Johansen
> Norway
>
|||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
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OukkDRj6FHA.1140@.tk2msftngp13.phx.gbl...
> 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/
> "Erling Johansen" <erlingpj@.hotmail.com> wrote in message
> news:e6sGVMj6FHA.3136@.TK2MSFTNGP09.phx.gbl...
>