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 viewer
Unsafe 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.3042
I've found an article that talks about this problem but they say that it fix in build 2153 http://support.microsoft.com/kb/917271
and 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?
View Complete Post