Posted by Erland Sommarskog on 09/02/05 17:01

Marcello (marc_atr@gmail.com) writes:
> Microsoft SQL-DMO (ODBC SQLState: 42000) Error 1827: CREATE/ALTER DATABASE
> failed.
>
> There's more, but it's in italian and I wouldn't know how to translate it
> properly.

Better to post the message than no message at all. Anyway, I found message
1827:

CREATE/ALTER DATABASE failed because the resulting cumulative database size
would exceed your licensed limit of %d MB per %S_MSG.

> It basically says that the requested size is exceeding some 2048mb limit.
> I can't see any limitation of this kind in the license. Is there
> something I am missing here?

Which edition do you have? I know that MSDE has a limitation of 2GB for a
database. I don't remember if this applies to Personal Edition as well.

If you are using MSDE, beware that your license for Enterprise Manager
does not entitle you to connect to MSDE with it.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Getting Avg to really ignore null values
• Prev in forum: Problem expanding a Db table (SQL Server 2000)
• Thread view: Re: Problem expanding a Db table (SQL Server 2000)

[Reply to this message]