Am un trigger CLR pe SQL Server 2005, ca din cutie, fara SP, fara hotfixs si asa.
Si din cind in cind nu mai pot modifica nimic in tabela cu triggeru
Cam asa ceva am in log
02/22/2010 12:20:09,spid69,Unknown,AppDomain 33 (xxx.dbo[runtime].32) created.
02/22/2010 12:20:09,spid55,Unknown,AppDomain 32 (xxx.dbo[runtime].31) unloaded.
02/22/2010 12:20:02,spid1s,Unknown,AppDomain 32 (xxx.dbo[runtime].31) is marked for unload due to memory pressure.
02/22/2010 12:19:59,spid55,Unknown,AppDomain 32 (xxx.dbo[runtime].31) created.
02/22/2010 12:19:56,spid1s,Unknown,AppDomain 31 (xxx.dbo[runtime].30) unloaded.
02/22/2010 12:19:56,spid1s,Unknown,AppDomain 31 (xxx.dbo[runtime].30) is marked for unload due to memory pressure.
02/22/2010 12:07:38,spid62,Unknown,AppDomain 31 (xxx.dbo[runtime].30) created.
02/22/2010 12:07:37,spid1s,Unknown,AppDomain 30 (xxx.dbo[runtime].29) unloaded.
02/22/2010 12:07:37,spid1s,Unknown,AppDomain 30 (xxx.dbo[runtime].29) is marked for unload due to memory pressure.
02/22/2010 12:00:29,spid55,Unknown,AppDomain 30 (xx.dbo[runtime].29) created.
Trigger are un SqlConnecion, sqlCommand si un SqlDataReader, le dadeam close dar nu exclud un leak....
Idei de unde sa apuc problema? Am trecut pe using toate si dau close la tot ce prind, altceva.
Multumesc!