Jeff,

what version of SQL Server? IN 7.0 you can configure the database to bloat automatically. It is in the properties of the DB in the Enterprise Manager.

Do you use the upsizing wizard? Do you get any error messages?

You can also upsize by creating that table structure on the server, create a remote view, open that in row buffering mode and append from your local table. If anything crashes, VFP will tell you the reason in message() and message(1).

Joerg Karpa


>Hello any SQL Server gurus (I hope):
>
>I'm trying to insert 1.5 million records from a Visual Foxpro table into a SQL Server table via remote views but my insert keeps failing at a specific number of records (362,240).
>
>I've created and configured my SQL database to a 3 gig size limit but I haven't specified any size settings for this particular table - I thought SQL Server would adjust it accordingly. I checked in the error log but didn't find anything that would indicate that the table or log file ran out of space.
>
>Any ideas as to what is happening here?
>
>Thanks for your help!
>
>-JT