Database Size

Error reads 'database sized exceeds licence limit of 2048 MB per database"
mean?It means you are using MSDE or Personal Edition. Run the following from
Query Analyzer or using osql
select serverproperty('Edition')
If it returns "Desktop Engine" or "Personal Edition" then this error is to
be expected, they have a 2GB file limit on the data files(s). In order to
support larger database sizzes you would need Standard Edition or partition
your data across multiple databases.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lila" <Lila@.discussions.microsoft.com> wrote in message
news:A698799C-84BB-4C28-9CAC-E36E314DFC45@.microsoft.com...
> Error reads 'database sized exceeds licence limit of 2048 MB per
> database"
> mean?|||It sounds like you're using MSDE which has a 2GB per db limit
"Lila" <Lila@.discussions.microsoft.com> wrote in message
news:A698799C-84BB-4C28-9CAC-E36E314DFC45@.microsoft.com...
> Error reads 'database sized exceeds licence limit of 2048 MB per
database"
> mean?sql