Hi
I have been getting this error, the last month or so when i try to generate a Inventory/Transfer Inventory Out/New.
Everything else is functioning fine.
SQL2005
Database 484MB
RMS 2.0.0150
Thank You
*This post is locked for comments
Hi
I have been getting this error, the last month or so when i try to generate a Inventory/Transfer Inventory Out/New.
Everything else is functioning fine.
SQL2005
Database 484MB
RMS 2.0.0150
Thank You
*This post is locked for comments
This can also happen if you reach the database size limit imposed by your version of sql server.
2000 MSDE = 2GB
2005 Express = 4GB
2008 Express = 4GB
2008 R2 = 10GB
2012 Express = 10GB
All paid retail version do not have a hard size limit but in theory is limited to the size of the storage device or array where the database is stored.
So make sure to check your free space also when you get an allocation error
I figured it out.
For anyone else wondering a easy way to edit the database is with the Server Management Studio software.
Thanks
Could you give me a step by step on that.
I know how to create databases but not to edit the auto growth
thanks
Seems your Database size is set to a limit. Increase the size limit of Primary file and check whether auto growth is set to a limit.
Sorry here is the error:
Could not allocate space for 'dbo.PurchaseOrder' in database...because the 'PRIMARY' file group is full
André Arnaud de Cal...
294,336
Super User 2025 Season 1
Martin Dráb
233,025
Most Valuable Professional
nmaenpaa
101,158
Moderator