If someone could point me in the right direction with this error message I would be very grateful.

I am inserting records from a text file through a remote view into a SQL Server table. The SQL Table has an insert trigger which updates other files from the inserted record's values.

I get through a little more than 30,000 records (out of more than 150,000 total) before I get this error message:

"Connectivity Error:[Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient memory to run this query."

I have 256 megs on the Server (which is dedicated to run SQL) and mine is the only database on the server.


Anyone have any ideas on how I can work around this?

Any suggestions would be greatly appreciated.


Thanks.