Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
avipenina
Starting Member
44 Posts |
Posted - 2008-05-27 : 10:18:02
|
Hi,I've a company that use SQL CLR from IIS that connect to the SQL and insert data to tables.every few days the server stop responding and i see those error in the sql event viewerUnsafe assembly 'hebfilts, version=0.0.0.0, culture=neutral, publickeytoken=null, processorarchitecture=msil' loaded into appdomain 9 (system.dbo[runtime].8).AppDomain 9 (system.dbo[runtime].8) unloaded.AppDomain 9 (system.dbo[runtime].8) is marked for unload due to memory pressure.the problem is fixed only when i restart the sql server service.now i use SQl Server 2005 SP2 build 9.0.3042I've found an article that talks about this problem but they say that it fix in build 2153 http://support.microsoft.com/kb/917271and i'v 3042.does my build include this fix?(i installed sp2 after RTM)if so how can i fix this error that i have? THX |
|
|
|
|