A bit of a background about what I need to do:

1) need to compress some BLOBs that store binary copies of real documents (sample attached)

2) in this test run I tried to push through 56 BLOBs where the biggest is about 40MB:

--uncompressed BLOBs stored here:

create table _Files (FileName varchar(200), FileSize int, FileContent varbinary(max))

--load the data here.... (irrelevant)

--compressed BLOBs will be stored here:

create table _FilesCompressed (FileName varchar(200), FileSize int, FileContent varbinary(max))

--an attempt to compress 56 documents blows up.

insert Into _FilesCompressed (FileName, FileSize, FileContent)

select f.FileName,

null,

dbo.dba_clrCompress(f.FileContent)

from _Files f

I will try to compress data by several documents at the time or using a cursor alltoghether and see....

Any other ideas?

PS: The ".NET Framework execution was aborted by escalation policy because of out of memory. " seems to be way too common according to the Google... No good.