Re: Databases SQL 2005 Express

Actually the limit is 32k but you will run out of memory long before you get
that many databases or users.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> wrote in message
news:efOsOoO0GHA.1268@xxxxxxxxxxxxxxxxxxxxxxx

Hi,

1. Yes, you could create unlimited number of databases in SQL Express [
Max db size 4 GB each]

2. It supports unlimited number of concurrent connections.


Even though it suppport many concutrent users and databases there is a
limitation of 1 GB RAM and 1 CPU.

Thanks
Hari
SQL Server MVP


"Dennis van Leur" <noreply@xxxxxxxxxxxx> wrote in message
news:MPG.1f678a11d4bda997989680@xxxxxxxxxxxxxxxxxxxxxxx
Hello,

Does anyone know how many databases i can create on SQL 2005 Express,
and how many connection SQL 2005 Express at the same time supports?

Thanks.

Dennis




.

Relevant Pages

  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Relational-to-OOP Tax
    ... Many SQL vendors has text mining features. ... Tutorial D isn't availible in production databases. ... The Third Manifesto,2 object functionality and the relational model are ...
    (comp.object)
  • Re: [PHP] is there a problem with php script pulling HTML out of database as it writes the page??
    ... I even had one tell me "SQL injection? ... about databases, server management, mail, or anything. ... I have a ghostwriter who keeps me active on the mailing lists. ...
    (php.general)
  • DataArchitect Version 3.5 Now On HP-UX
    ... DataArchitect is a powerful tool that provides ERD capability like PowerDesigner as well as the ability to graphically reverse engineer, create and modify a database through ODBC and perform advanced SQL functions. ... Data Architect is an emerging enterprise tool for designing databases at all levels of an organization using the same concepts found in tools costing thousands of dollars! ... Minimize/Maximize feature on diagram objects ...
    (comp.sys.hp.mpe)
Loading