One of my users got an error that read :
"Could not allocate space for object <tablename> in database <databasename> because the 'PRIMARY' filegroup is full."
What follows are a list of steps followed(and the settings on EM - we use SQL Server 7.0)
i) Freed up about 2GB of space on the disk(since I assumed that the problem occured due to lack of free space)
ii)Went to EM and right clicked on the DB and in the Properties option chose the 'Options' tab and checked 'Truncate Log on checkpoint'...(other than this - only 'Auto create statistics' and 'Auto update statistics' are checked)
iii)Settings for the DB in EM properties option for the MDF and LDF files are :
File Properties :
Automatically grow file (selected)
File growth - By percent(10%)
Maximum File size - Unrestricted filegrowth (selected)
This problem still tends to recur even though there is enough free space on the disk...am I missing something out here??or do I have to make any changes in the settings?