I tried to add a row to a table. That time the “Structure less material operation error: Could not allocate space for object. Because the ‘PRIMARY’ filegroup is full.” Error occurred and row is not added.

I tried below solutions:

1. Increase autogrowth size and set maximum size to unlimited.

2. Check on Filegroups -> primary- Autogrowth All Files check box check on.

3. Set maximum size to -1 by executing a query.

4. Compression

5. Restart SQL server by applying these solutions and also restart system.

These solutions are not worked.

In my database there is space, because when try to add through SQL management studio, the row is added. But by using application, the row is not added, and this error occurred.

Sometimes the row added, but sometimes issue occurred. Is there is any other solution for this issue?

​I tried to add a row to a table. That time the “Structure less material operation error: Could not allocate space for object. Because the ‘PRIMARY’ filegroup is full.” Error occurred and row is not added. I tried below solutions:1. Increase autogrowth size and set maximum size to unlimited.2. Check on Filegroups -> primary- Autogrowth All Files check box check on.3. Set maximum size to -1 by executing a query.4. Compression5. Restart SQL server by applying these solutions and also restart system.These solutions are not worked.In my database there is space, because when try to add through SQL management studio, the row is added. But by using application, the row is not added, and this error occurred. Sometimes the row added, but sometimes issue occurred. Is there is any other solution for this issue?   Read More

​