Number of databases SQL server allowed?

[kthomas]

Hi everyone,

We thought of creating each sales object into a database itself. But this will present problem when we run out of databases (estimate that we will have about 10000) max sales subject to be had during my life time "anyway". This may sound idiotic for anyone to think of doing this way ...
Frontend developing technique is delphi. And it can take about 1 minute or more to load all tables ... I can see users frustrating when they swich to different sale object ..but most of the time, they will only work one sale per day per user.

Your opinion is helpful.

KT

 

[foxdev]

The answer to the question you asked in your Subject is:
32,767 is the maximum number of databases per server.

As to the idea of having each "sales object" having its own database - it sounds bizarre, but maybe it would make more sense if we knew why. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org