Does anyone know the Maximum Size of GetRowSet?

Does anyone know the maximum size of sql server's GetRowSet command?
We are trying to a 5gb table using SqlServer2000's GetRowSet command, and
after it fails with a 'connection error', we have found a suspicious temp
file that is almost exactly 2gb in size in the os temp folder.
We have plenty of drive space, plenty of tempdb space, we have checked
everything we can think of, moved the data to the temp HD and still it
fails approx 40% into the load.
The file we are reading is a foxPro file and we are trying to Get the data
into Sql Server.
Anyone have any thoughts on this?
Thanks.
Charles..it is possible this was programmed with 32-bit convention,
in which 2 or 3GB will be the limit. If you have W2K AS,
try booting with the /3GB flag and see if the temp file
goes to exactly 3GB before bombing out
>--Original Message--
>Does anyone know the maximum size of sql server's
GetRowSet command?
>We are trying to a 5gb table using SqlServer2000's
GetRowSet command, and
>after it fails with a 'connection error', we have found a
suspicious temp
>file that is almost exactly 2gb in size in the os temp
folder.
>We have plenty of drive space, plenty of tempdb space, we
have checked
>everything we can think of, moved the data to the temp
HD and still it
>fails approx 40% into the load.
>The file we are reading is a foxPro file and we are
trying to Get the data
>into Sql Server.
>Anyone have any thoughts on this?
>Thanks.
> Charles..
>
>.
>