error on mssql10

Customer Support Customer Only Discussion
1

‘tblNews (dbo)’ table

  • Unable to modify table.
    Could not allocate space for object ‘dbo.Tmp_tblNews’ in database ‘mizrach*****’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

whats up with this? support creayed this for me, and i havent even started using it yet.

Thanks

2

well, there is really not much I can answer without more info, but with the little i have I can see you hve no free space on the database, or, 0.48MB rather.
That tblNews has over 14MB in use, and you have a 20MB DB, it is split off for some logging to. I increased it to 30MB and it should work, but basically the database was full :slight_smile:

Also since you gave the start of the name i was able to set the permissions to see it in SQL Studio.

3

great - thanks for the response Stephen!