I am posting this in the .NET Framework inside SQL Server forum as I assume the issue is related to CLR / SQL Server. Please let me know if this is the incorrect forum.
I am receiving the following error in the event log:
AppDomain [DB_NAME].dbo[runtime].5253 was unloaded by escalation policy to ensure the consistency of your application. Out of memory happened while accessing a critical resource.
System.Threading.ThreadAbortException: Exception of type 'System.Threading.ThreadAbortException' was thrown.
The system that this is occurring on is a Windows Server 2003 R2 SP2 (32 bit), SQL Server 2005 SP2 with 8 GB of RAM:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
9.00.3042.00 SP2 Standard Edition
The CLR assembly is relatively simple and is referenced by both store procedures as well as by a table trigger (update). Essentially the CLR assembly instantiates an object (in a referenced webservice on a separate&
View Complete Post