I don't think an "upgrade" to image would be painful, but I would considder it a "downgrade" to change from binary to image. There is much more overhead using image instead of binary (especially since I only need to store 1K on the field (well another case I need to store 2K but binary is still sufficient). I read that image is beeing outfaced (replaced by varbinary(MAX)).
I am still trying to find a function that will help me chack the passed binary parameter size, but I have not had any luck with that so far. (hints are welcome<s>)
Well at least I am glad that you find my dillema odd (and that I am not just overlooking something obvious {again<s>})
Einar
>the upgrade to image might not be painful.
>The other option is to check the size of your binary param before you call the sp. and throw exp then.
Semper ubi sub ubi.