Fandy08 (2/27/2015)

---

I made some test with varbinary(max) datatype (instead of image) and the following sequence works, LOB data is released and canceled from database.

So the problem is limited to (deprecated) image datatype.

1) UPDATE tbl SET imagecol = NULL for all images you want to remove.

2) Run sp_spaceused to note the current space usage.

3) ALTER INDEX ALL ON tbl REORGANIZE on the table(s) in question.

4) Run sp_spaceused to compare.