Problem expanding a Db table (SQL Server 2000)

[Marcello]

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.
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?

Thank you in advance

- andrea

[Erland Sommarskog]

Marcello (ma******@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, es****@sommarskog.se

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

[Andrea B. Previtera]

> If you are using MSDE, beware that your license for Enterprise Manager

does not entitle you to connect to MSDE with it.

Unluckily I discovered we're running MSDE. Now I am up to buy the full SQL
2000 Server version, which makes
me think: how many client licenses will we need? We've got 50 computers
connecting to a single application which
then connects to the SQL server. 50 licenses... or just one?

- bee

[John Bell]

Hi

Check out the different licencing options at
http://www.microsoft.com/sql/howtobuy/default.mspx

John
"Andrea B. Previtera" <an*****@instation.it> wrote in message
news:df**********@carabinieri.cs.interbusiness.it. ..

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

Unluckily I discovered we're running MSDE. Now I am up to buy the full SQL
2000 Server version, which makes
me think: how many client licenses will we need? We've got 50 computers
connecting to a single application which
then connects to the SQL server. 50 licenses... or just one?

- bee