R&R grabbing too much memory.

[Chris_Ransom_(Guest)]

We are using R&R SQL 6.5, SQL Server 7.0 and NT Server 4.0 with Windows 9x Workstations. Sometimes when running a complex report we notice that it brings our database on the same server to a complete halt. Is it possible to limit the amount of memory that R&R can grab?

[kfleming]

There is not a way to limit the databases resources that would be used when a report is run.__We issue a SELECT statement that is sent to the ODBC driver who in turn queries the server to return the data.______Kathleen__R&R Support