[Macromedia][SQLServer JDBC Driver][SQLServer]Internal

[gsmadman]

I'm running an export process which takes data and dumps it to a text file. The
query used to build it can contain large amounts of information in the select
statement. When it gets really large, I get this error

Error Executing Database Query.Internal Query Processor Error: The query
processor ran out of stack space during query optimization.

and the process stops.

Is there a way to increase the amount of stack space made available to the
driver? I'm giving the JVM 1GB of memory, although it never gets above 220MB or
so.

I'm running this on a W2K server dual cpu box with 2GB RAM, CFMX 6.1 and
SQLServer 2000

Any advice or pointers would be greatly appreciated.

[PaulH *TMM*]

gsmadman wrote:

> I'm running an export process which takes data and dumps it to a text file. The
> query used to build it can contain large amounts of information in the select

use DTS, that's what it's there for.