HQ Run-time error, Not enough storage

Apr 10, 2008 1 Replies
K

I get the following error when I want to see Event log: Run-time error '-2147024882 (8007000e)': Not enough storage is available to complete this operation.



Also I get the error when taking a Detailes Sales Report for a long period (works with some months, gives error with a year): The report data could not be loaded due to the following error: (-2147417848) Automation error The object invoked has disconnected from its clients.



Can anyone tell what may be the reasons for the errors?



HQ database size is about 1.8 GB Database server is: Intel Xeon 1.86 GHz



4 GB RAM Microsoft Windows Server 2003 R2 Standard Edition SQL Server 2005 Standard Edition

Koit Lahesoo



Vote
Twitter Facebook LinkedIn
M

One possibility is that if your database was created with Microsoft SQL Server Desktop Engine (MSDE) and then you upgraded the SQL Server and database to SQL 2005. The upgrade may have retained the database setting from the MSDE which limits the size of the database to 2GB.

You could use SQL Server 2005 Management Studio to check the database property settings and ensure it is set to grow atomatically and does not have a maximum size.

ie. connect to SQL Server Manager Studio -> Go to database folder -> Right Click Database & select properties -> then go to File and check the autogrowth settings.

2nd Possibility which i doubt is that maybe you don't have enough space on your harddrive. BUT I DOUBT THAT??

Without further information that's the only thing i can think of, hope this helps.

"Koit Lahesoo" wrote:

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required