There is insufficient system memory to run this query

There is insufficient system memory to run this query - system.web

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pavel Spaleny - 19 Jul 2008 10:13 GMT

Hi,
I have a big troupble with one MS SQL server. There is 4GB RAM and using is
about 2GB RAM.

I need registr .NET assembly system.web bec I need use httputilizie to
encode some special chars (e.g. space to ).
But when I try to registr assembly, I have this error : There is
insufficient system memory to run this query

I use this query:

CREATE ASSEMBLY SystemWeb from
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Web.dll'
with permission_set = unsafe

thanks a lot

Reply to this Message

Erland Sommarskog - 19 Jul 2008 18:15 GMT

> I have a big troupble with one MS SQL server. There is 4GB RAM and using
> is about 2GB RAM.
[quoted text clipped - 9 lines]
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Web.dll'
> with permission_set = unsafe

When I tried to load the assembly into my database, I got the output below.
This may or may not be resolvable, but I think you should find a different
solution for your problem at hand.

Warning: The Microsoft .Net frameworks assembly 'system.web, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=x86.' you are registering is not fully tested in SQL Server hosted environment.
Warning: The Microsoft .Net frameworks assembly 'system.drawing, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
Warning: The Microsoft .Net frameworks assembly 'system.directoryservices, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
Warning: The Microsoft .Net frameworks assembly 'system.directoryservices.protocols, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
Warning: The Microsoft .Net frameworks assembly 'system.enterpriseservices, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=x86.' you are registering is not fully tested in SQL Server hosted environment.
Warning: The Microsoft .Net frameworks assembly 'system.runtime.remoting, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
Msg 10300, Level 16, State 2, Line 1
Assembly 'System.Web' references assembly 'system.web, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: version, culture or public key mismatch). Please load the referenced assembly into the current database and retry your request.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message