>
>Einar,
>
>Try an image column instead.
Hmmmmm I had to read up on it a little but it seems that it should work. Have you ever used an image column in this fashion before?
In the past couple of days I have been pondering if I should redesign my table (41 1Kb binary rows instead of 41 1Kb binary columns) or if I should utalize the new feature of SQL2005 where row size limit can exceed 8Kb. Now rereading your post I have another scenario to ponder.
I think redesigning (I am at a very early stage of table design so it doesn't matter if I have to redesign) will be the best option (most flexible and fastest). Any thoughts on this?
Einar
Semper ubi sub ubi.