Database Size Limitation of SQL Server 2000 Personal Edition ?

I would like to know is there any limitation to the size of data file of SQL
Server 2000 Personal Edition. Just like the MSDE, the data file size cannot
be greater than 2GB (From memory) ?No there is no limitation.
But there is limitation on RAM usage

Database Size Limitation of SQL Server 2000 Personal Edition ?

I would like to know is there any limitation to the size of data file of SQL
Server 2000 Personal Edition. Just like the MSDE, the data file size cannot
be greater than 2GB (From memory) ?
No there is no limitation.
But there is limitation on RAM usage

Database Size Limitation of SQL Server 2000 Personal Edition ?

I would like to know is there any limitation to the size of data file of SQL
Server 2000 Personal Edition. Just like the MSDE, the data file size cannot
be greater than 2GB (From memory) ?No there is no limitation.
But there is limitation on RAM usage

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
> No, it is limited by the disk's capacity
>
> Yes, 4GB
>
> 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...
>sql

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.
Thanks
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
>
|||Dear Uri,
Thank you for your advice.
Peter
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%234uAmOj4GHA.4196@.TK2MSFTNGP05.phx.gbl...
> Peter
> No, it is limited by the disk's capacity
>
> Yes, 4GB
>
> 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...
>

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
>