Database size for SQL Server 2000 Personal Edition ?

Is there any database size limit for SQL Server 2000 Personal Edition ? Is
it 2GB ?
Also, is there any database size limit for SQL Server 2005 Express ?
From end user point of view, is there any difference between SQL Server 2000
and SQL Server 2005 Express ? Is it possible to get SQL Server 2005 Express
on CD ROM instead of downloading from the Web ?
Your advice is sought.
ThanksPeter
> Is there any database size limit for SQL Server 2000 Personal Edition ?
> Is it 2GB ?
No, it is limited by the disk's capacity
> Also, is there any database size limit for SQL Server 2005 Express ?
Yes, 4GB
> From end user point of view, is there any difference between SQL Server
> 2000 and SQL Server 2005 Express ? Is it possible to get SQL Server 2005
> Express on CD ROM instead of downloading from the Web ?
SQL Server 2005 Express is coming along with VS2005 installation.
You can download SQL Server 2005 Express and burn out to DVD /CD... .
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:esv3UGi4GHA.3396@.TK2MSFTNGP04.phx.gbl...
> Is there any database size limit for SQL Server 2000 Personal Edition ?
> Is it 2GB ?
> Also, is there any database size limit for SQL Server 2005 Express ?
> From end user point of view, is there any difference between SQL Server
> 2000 and SQL Server 2005 Express ? Is it possible to get SQL Server 2005
> Express on CD ROM instead of downloading from the Web ?
> Your advice is sought.
> Thanks
>|||Dear Uri,
Thank you for your advice.
Peter
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%234uAmOj4GHA.4196@.TK2MSFTNGP05.phx.gbl...
> Peter
>> Is there any database size limit for SQL Server 2000 Personal Edition ?
>> Is it 2GB ?
> No, it is limited by the disk's capacity
>> Also, is there any database size limit for SQL Server 2005 Express ?
> Yes, 4GB
>> From end user point of view, is there any difference between SQL Server
>> 2000 and SQL Server 2005 Express ? Is it possible to get SQL Server 2005
>> Express on CD ROM instead of downloading from the Web ?
> SQL Server 2005 Express is coming along with VS2005 installation.
> You can download SQL Server 2005 Express and burn out to DVD /CD... .
>
> "Peter" <Peter@.discussions.microsoft.com> wrote in message
> news:esv3UGi4GHA.3396@.TK2MSFTNGP04.phx.gbl...
>> Is there any database size limit for SQL Server 2000 Personal Edition ?
>> Is it 2GB ?
>> Also, is there any database size limit for SQL Server 2005 Express ?
>> From end user point of view, is there any difference between SQL Server
>> 2000 and SQL Server 2005 Express ? Is it possible to get SQL Server 2005
>> Express on CD ROM instead of downloading from the Web ?
>> Your advice is sought.
>> Thanks
>