I tried to add a row to a table. That time I get an error:
Structure less material operation error: Could not allocate space for object. Because the ‘PRIMARY’ filegroup is full
and the row is not added.
I tried these solutions:
- Increase autogrowth size and set maximum size to unlimited.
- Check on Filegroups -> primary- Autogrowth All Files check box check on.
- Set maximum size to -1 by executing a query.
- Compression
- Restart SQL Server by applying this solutions and also restart system.
I have space on my hard disk.
But these solutions did not work. Sometimes, the row is added, but sometimes, that issue occurred. Is there is any other solution for this issue?
I have to add rows. In my database there is space, because when try to add through SQL Server Management Studio, the row is added.
SHABLA M is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.