Hello.

I seem to be having the same problem, and am hoping you can help me. Unfortunately, I am very green when it comes to SQL Server as most of my db experience is with MS Access. We use SQL server when we are forced to update, do to db size.

My application produces a System Resource Exceeded error during routines which cause extreme file growth. I've reviewed the posts in this thread but don't understand the post related to this problem.

We are using MS SQLServer 2008 R2 which is installed on a Windows 7 machine. I've tried AWE and the switch referenced however the error continues.

The routine which causes the error is very simple.

The first thing the code does is to create a group of records that we want to process. The group can range from 20,000 to 200,000 records. This routine always works flawlessly.

Next, the routine that causes the system resource exceeded error runs. This routine opens

a recordset of all of the selected records, then loops through the recordset one time, updating each record in a manner which certainly causes the database size to grow significantly.

When I use the routine to update 20,000 records, it works every time, without producing any errors.

When I use the routine to update 100,000 records, it fails every time with the system resource error.

The machine running MS SQL Server 2008 R2 has all of the current service packs and is a dedicated machine with 8GB running windows 7 in 64 bit mode although the 32-bit version of SQL Server is installed on the machine.

The workstation is an XPpro sp3 running ms access 2000 and the sql table is linked using odbc.

The domain is a LAN and the controller is Win2003 Server.

Any help will be appreciated greatly.