Porting SQL IMAGE to VARBINARY(MAX)
You may be looking to change a column from data type IMAGE to VARBINARY(MAX) in MSSQL2008.
Here is something you should be aware of:
"Partial updates are not supported on columns that have a FILESTREAM as a source."
You will get the above error message if you try something like the statement below in SQL2008
UPDATE [tbl_MDA_Media] set [Media] .WRITE(0x1a5175616...4757778797a828384, 512, 512) , LastModified = '2013-06-26 11:12:00' where [MediaID] = '7724'