Re: How many databases can exist in sql server?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tim Sullivan (tsullivan_at_websul.net)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 09:45:58 -0800

Thanks Andrew. That number looks familiar! A small int
perhaps!

>-----Original Message-----
>32,767 per instance of sql server.
>
>--
>
>Andrew J. Kelly
>SQL Server MVP
>
>
>"Tim Sullivan" <tsullivan@websul.net> wrote in message
>news:1333501c3f708$85c73590$a601280a@phx.gbl...
>> Hi,
>>
>> I once read a reference that outlined the limits in
>> database size and number of databases allowed in sql
>> server. Can anyone point me to it?
>>
>> I am goin gto set up a web site to serve many (200+)
>> independent health care workers. I am required to set
up
>> each user in their own database. How many databases
can
>> I configure in sql server?
>>
>>
>> Thanks
>>
>> Tim
>
>
>.
>

Relevant Pages

  • Idiomatic Expressions to Operating System Architecture: Transforming Rigids
    ... <Subject: Re: Idiomatic Expressions to Operating ... <endpoint during a single session * DATABASE + by ... <statements is a new feature of SQL Server 2005. ...
    (sci.math)
  • Re: High availability
    ... Thanks Geoff and Andrew for the good info, I guess my best bet is to scale up ... setting up sql server failover clustering, replication, High availability, ... Senior Database Administrator ...
    (microsoft.public.sqlserver.clustering)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)