Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insufficient Memory Error
Message
From
17/09/1999 09:41:26
 
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00265524
Message ID:
00265869
Views:
24
Michael,

I do have the memory configured to allocate dynamically. I am uploading the data one record at a time by appending new records through a remote view. I realize that there is a bulk insert method of doing this, but I am converting an old fox 2.6 app and the code is already there to parse the text file that I am importing. The error has been occuring in VFP.

I think I have found a solution however. I SET NOCOUNT ON and it seems to be working. I started my import last night and when I got in this morning it had already imported over 150,000 records.

Thanks for the help though.

Eric Grover
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform