Primary filegroup is full.

I seem to be having problems with a very simple install of MSDE on a
Windows 2000 Server. When attempting to add new records, I receive
the message "Could not allocate space for object 'MyTable' in database
'MyDatabase' because the 'PRIMARY' filegroup is full."

I have dealt with countless issues like this in the past and they have
been easily resolved due to max limit of MSDE, trans log full, or the
hard drive where the database is stored is full. None of these appear
to be the case in this instance. The system has been working fine for
about a year.

The Master database is 11 MB. MyDatabase is 33 MB. The log files are
both under 1 MB. I have 730 MB of storage available on the drive
where the database is stored.

I downloaded MSDE off of Microsoft's website and installed with the
following switches: BLANKSAPWD=1 SECURITYMODE=SQL. I create a user
in MSDE that is the DBO for MyDatabase. Other than that, I make no
changes to the default installation.Giadis (lonewolf3557@.hotmail.com) writes:
> I seem to be having problems with a very simple install of MSDE on a
> Windows 2000 Server. When attempting to add new records, I receive
> the message "Could not allocate space for object 'MyTable' in database
> 'MyDatabase' because the 'PRIMARY' filegroup is full."
> I have dealt with countless issues like this in the past and they have
> been easily resolved due to max limit of MSDE, trans log full, or the
> hard drive where the database is stored is full. None of these appear
> to be the case in this instance. The system has been working fine for
> about a year.
> The Master database is 11 MB. MyDatabase is 33 MB. The log files are
> both under 1 MB. I have 730 MB of storage available on the drive
> where the database is stored.

Have you verified with sp_helpdb that the database has "Unlimited" in
maxsize and 10% in Growth? These are values in the second result set.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

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