I keep getting this error when i send a large document into sql server with ADO.NET System.Data.SqlC

microsoft.public.sqlserver.programming

23 Sep 2005 7:51 PM

Daniel

I keep getting this error when i send a large document into sql server with
ADO.NET System.Data.SqlClient.SqlException: XML parsing error: Not enough
storage is available to complete this operation. I have about 8 gigs of
memory on the machine and sql server isnt using even half of it. any way to
configure sql server to use more of the memory?

23 Sep 2005 8:16 PM

Yosh

Edit the properties on the server (sql) in Enterprise Manager and go to the
memory tab.

Yosh

Show quote

"Daniel" <softwareengineer98***@yahoo.com> wrote in message
news:eVTn2aHwFHA.2212@TK2MSFTNGP15.phx.gbl...
>I keep getting this error when i send a large document into sql server with
> ADO.NET System.Data.SqlClient.SqlException: XML parsing error: Not enough
> storage is available to complete this operation. I have about 8 gigs of
> memory on the machine and sql server isnt using even half of it. any way
> to
> configure sql server to use more of the memory?
>
>

28 Sep 2005 6:07 PM

hugochb

I'm getting exactly the same error, it just started recently too, perhpas it's a new Microsoft hotfix tha has reduced the memory limit?

Daniel wrote:
Show quote

> *I keep getting this error when i send a large document into sql > server with
> ADO.NET System.Data.SqlClient.SqlException: XML parsing error: Not > enough
> storage is available to complete this operation. I have about 8 gigs > of
> memory on the machine and sql server isnt using even half of it. any > way to
> configure sql server to use more of the memory? * -- hugochb ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------