There is insufficient system memory to run this query - system.web
in [Programming SQL]
|
From: Pavel Spaleny Pavel on 19 Jul 2008 05:13 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
From: Erland Sommarskog on 19 Jul 2008 13:15 Pavel Spaleny (Pavel Spaleny(a)discussions.microsoft.com) writes: > 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 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. -- Erland Sommarskog, SQL Server MVP, esquel(a)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
|
Pages: 1 Prev: Best way to send a result query via e-mail? Next: Inject numbers frmo 1-etc for a column |