HQ Run-time error, Not enough storage

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

Reply to
Koit Lahesoo
Loading thread data ...

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:

Reply to
MCH

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.