Posted on 2003-10-23
I am trying to import a large amount of data into SQL server. Currently the data is in a proprietary format and basically all I have is an executable that automatically exports the data the SQL server. But it doesn't even get about halfway through when it returns an ODBC error message that says there is insufficient system memory to run this query. At that point I have to restart the SQL server service because it basically crashes SQL server anything from then on will give me that same error including trying to access other databases. The SQL server has 1.5Gigs of ram and when the operation is execute it starts with about 1.3 gigs available when it is running I noticed that the SQL server process slowly increases its memory until it gets around 120 megs and then the system dies with its out of memory message but the system clearly has atleast 1.1 gigs still available....